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

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.