| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range color formatting
I have a column with multiple values. e.g. When the value of A1 changes, the
A1 changes color and the row (A1:A30) should change accordingly; and so on... I am using the If .Column = 1 Then Select Case and works beautiful for a cell. But I don't know how to extend it to a range. Where do I insert the range to match the color of that cell? Thanks for your help. Regards, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color formatting | Excel Worksheet Functions | |||
| Formatting the color of a range of cells based on the value of one cell | Excel Worksheet Functions | |||
| Color Formatting | Excel Discussion (Misc queries) | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) | |||
Threaded Mode
