Conditional Formatting using different cell

Statesman · Oct 21, 2002

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 "Calculation Correct" based on the two formula above being true. And conversely how would I get the same cell to go RED and have the word "Recalculate" based on the either of the results being false?

austim · Oct 21, 2002

Statesman,

This works for me in ExcelXP.

in D46 enter the following formula
=if(cell1*cell2=1,"Calculation Correct","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

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 · Oct 21, 2002

Thanks Austim,

That method worked a treat.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Conditional Formatting using different cell

Statesman

Mechanical

austim

Structural

Statesman

Mechanical

Similar threads

Part and Inventory Search

Sponsor