Conditional Formatting using different cell

[Statesman]

How would I conditionally format a cell based on the values of two other cells ?

i.e One cell has the following formula =IF(D45>45,1,0)
and another cell has the formula =if (D45<=D32,1,0)

How can I get a cell,say, D46 to go green and have the word &quot;Calculation Correct&quot; based on the two formula above being true. And conversely how would I get the same cell to go RED and have the word &quot;Recalculate&quot; based on the either of the results being false?

 

[austim]

Statesman,

This works for me in ExcelXP.

in D46 enter the following formula
=if(cell1*cell2=1,&quot;Calculation Correct&quot;,&quot;Recalculate&quot

Now conditionally format the cell using the conditional format wizard with two conditions:

Condition 1
if cell value is
equal to
Calculation Correct (excel will add =&quot; &quot
select Green colour in the format window

Condition 2
if cell value is
not equal to
Calculation Correct
select red colour in format window

 

[Statesman]

Thanks Austim,

That method worked a treat.