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