Excel 2007 - Is there a way to color a cell when the IF statement is TRUE

Hi,

I’m not sure if this is possible with a formula, however I have the below formula and I would like the cell to be a different color when it returns the TRUE value and stay the same color when it returns the FALSE Value ($M10)

=IFERROR(LOOKUP(2,1/INDEX('CONTRACT PRICES'!$E:$E=$B10,0),'CONTRACT PRICES'!$T:$T),$M10)

Thank you in advance for your help.
Rique

Well, you can't color it with the IF formula, but you can add conditional formatting. For instance, select the cell that stores the result and apply these CF rules (use different formats for each rule):

Rule 1: =$M10
Rule 2: =D3<>$M10 (replace D3 with the cell your formula is actually in)

- Moo

Hi Moo,

Thanks i have used conditional Formatting and this has helped.

Regards,
Rique