Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In conditional formating, is it possible to do?
Hi and thanks for the previous helpful tips you offered, it was really
helpful! Is it possible at all to do the following? In conditional formatting, Formula is: IF the cell A1 is cell shaded with say color blue (FormatConditions.Interior.ColorIndex = 55), set this cell A2 to color red, else FALSE. So my question is, if conditional format can detect a cell pattern color to use it for an IF formula? Thanx so much!! |
#2
|
|||
|
|||
In article ,
Kel wrote: So my question is, if conditional format can detect a cell pattern color to use it for an IF formula? No. Of course, if the reference cell is colored using Conditional Formatting, the same condition can be used to color the second cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional Formating & Rand() function | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |