Conditional formatting - highlight range of cells when it equals a cell

Hi,

I have a row of numbers which i would like to highlight once it equals another cell. It'll make sense once you open the attachment.

So looking at cells F2:AE2, is there a conditional formatting formula to highlight at which point the sum of these cells equals C2?

So in the example i have given, F2:O2 would equal C2 and the rest of the cells P2:AE2 should be in red.

Hope that makes sense

Thanks

Hi kingkong321

See attached.

Rule 1: =AND(F$2<>"",SUM($F2:F$2)=$C$2)

Rule 2: =AND(F$2<>"",SUM($F2:F$2)<>$C$2)

Originally Posted by Norie

You could try this.

Select F2:AE2, goto conditional formatting, select the Use formula... option and enter this.

=SUM($F2:F2)>$C2

Then format as required.

Worked! Thanks a lot.