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.

We have tried to capture the background color of a cell that is conditionally
formatted, but with no luck. The best I can do is to copy the cells into a
Word table; copy the table back into Excel and test the color with VBA!?!

So until Excel decides to expose the colorcode, just examine the conditional
equations and decide that way.
--
Gary's Student


"Shu of AZ" wrote:

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.

GS

See Chip Pearson's site for code to detect CF colors.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP


On Mon, 18 Dec 2006 15:27:01 -0800, Gary''s Student
wrote:

We have tried to capture the background color of a cell that is conditionally
formatted, but with no luck. The best I can do is to copy the cells into a
Word table; copy the table back into Excel and test the color with VBA!?!

So until Excel decides to expose the colorcode, just examine the conditional
equations and decide that way.