In conditional formating, is it possible to do?

[Kel]

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!!

 

[JE McGimpsey]

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.