Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down lists and condtional formating
I have a spreadsheet for a 24 hour rota, i have added drop down boxes and
want to use conditional format the options, I have 5 selections on my drop down list but formating will only allow me to colour 3, any way around it? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down lists and condtional formating
Can be done with macro code. If you want to use this option then please post
the following information. The cell references to have the conditional format. The 5 values in the drop downs. (If not the same for each cell reference then need to match these with the cell references.) The formatting required for each value. -- Regards, OssieMac "grissom 345" wrote: I have a spreadsheet for a 24 hour rota, i have added drop down boxes and want to use conditional format the options, I have 5 selections on my drop down list but formating will only allow me to colour 3, any way around it? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down lists and condtional formating
Hi,
1. You can get 5 formats if you don't mind that 2 of them will only be font color changes by applying the three conditional formats and a custom format in the Format, Cells, Number tab, Custom dialog box. 2. You can upgrade to 2007 which allows an unlimited number of conditional format and much more. 3. You can use code such as the following: Sub FormatCells() Dim cell As Range For Each cell In Selection With cell.Interior Select Case cell Case Is < 0 .ColorIndex = 39 Case Is = 0 .ColorIndex = 37 Case 1 To 10 .ColorIndex = 34 Case 11 To 25 .ColorIndex = 35 Case Else .ColorIndex = 40 End Select End With Next cell End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "grissom 345" wrote: I have a spreadsheet for a 24 hour rota, i have added drop down boxes and want to use conditional format the options, I have 5 selections on my drop down list but formating will only allow me to colour 3, any way around it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condtional Formating | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Condtional formating -- any wildcard use? | Excel Discussion (Misc queries) |