Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Coloring
Cell A1 is red based on a conditional format I have set up. I want to do the
following: If cell A1 is red because of conditional format, then make cell A2 red. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Coloring
Use "Formula Is", rather than "Cell Value Is" in your Conditional Formatting
condition, then set up an appropriate formula which looks at the value in A1, so for example CF/ Formula Is/ =A1500 -- David Biddulph MrMarbles wrote: Cell A1 is red based on a conditional format I have set up. I want to do the following: If cell A1 is red because of conditional format, then make cell A2 red. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Coloring
Apply CF with the same conditions to A2.
HTH Bob "MrMarbles" wrote in message ... Cell A1 is red based on a conditional format I have set up. I want to do the following: If cell A1 is red because of conditional format, then make cell A2 red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell coloring | Excel Discussion (Misc queries) | |||
coloring a cell if blank | Excel Worksheet Functions | |||
Cell coloring according to the other cell's value | Excel Worksheet Functions | |||
Cell Coloring | Excel Worksheet Functions | |||
Coloring Active Cell | Excel Worksheet Functions |