Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Row Colours
Hi
I'm looking for a VBA script to colour all the cells in a row (or even just some in a row) a certain colour dependent on the value in the 'A' column cell. For instance, if cell A1 is Jan-03 then the whole row should be coloured light yellow (or whatever the RGB equivalent is); if cell A2 is Feb-03 then the whole row should be coloured light green; and so on... Is this possible? Thanks for you help. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting / Cell Fill Colours | New Users to Excel | |||
how do i get more than 3 colours in conditional formatting | Excel Discussion (Misc queries) | |||
colours missing in conditional formatting. | Excel Worksheet Functions | |||
Conditional Formatting with Colours / Colors | Excel Worksheet Functions | |||
is it possible to have more than 3 colours in conditional format | Excel Worksheet Functions |