My apologies, I might not have made it very clear.

A1=1 but never changes except for a conditional format that changes it to
red if another cell meets the criteria. If the other cell doesn't meet the
criteria, it remains a 1 with no fill. I can do a formula to recognize the
cell that caused A1 to turn red but there are other items in the background
that warrant only recognizing A1 has turned red.

In another cell, I need to do an IF statement that causese a formula to run
if A1 is red.

What is the formula to have a cell do something if another cell's
conditional format is true and reacts.

************************************

=IF(A1=0,1)

The same condition applies
--
Gary''s Student


"Shu of AZ" wrote:

If A1=1, and B1 has a conditional format that changes the color to red if A1
equals 1, what is the IF formula to change C1 to a zero if B1 is red.