Conditional Formatting With Sum of Cells with Formulas - Cant get it to work

[bigbavarian]

Hello.

I am trying to add some conditional formatting to three cells that will show Green when the sum of three cells are equal to one other cell. And it will be red if if the sum of the three cells are not equal to the one cell. For some reason it isn't working across all three cells.

The three cells are formulas so I don't know if it is tripping up on that or the rounding issue or what.

I tried to attach a file. I hope it worked.

Please help.

Stephen

[bigbavarian]

You will see the cells I am working on as they are highlighted. But in case you don't...

Green
=$G$16:$G$18
=((SUM(G16:G18))<>G2)


Red
=$G$16:$G$18
=((SUM(G16:G18))=G2)

[p45cal]

The CF formula needs to have absolute, or semi absolute references, eg.
=((SUM(G16:G18))=G2)
becomes:
=((SUM($G$16:$G$18))=$G$2)

[bigbavarian]

Ahh. That makes sense. Your the best. Thank you very much.