Conditional Formatting using different cell
Conditional Formatting using different cell
(OP)
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?
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?
RE: Conditional Formatting using different cell
This works for me in ExcelXP.
in D46 enter the following formula
=if(cell1*cell2=1,"Calculation Correct","Recalculate")
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 =" ")
select Green colour in the format window
Condition 2
if cell value is
not equal to
Calculation Correct
select red colour in format window
RE: Conditional Formatting using different cell
That method worked a treat.