help with a formula for conditional formatting

[baldi]

I need a not equals formula for a cell.
if cell A does not equal the sum of cell B and cell C. Cell A will turn red.

any help would be great
thanks

 

[palaeontology]

Try ...

=A1<>SUM(B1,C1)

Kind regards,

Chris

 

[mumps]

In cell A1: =A1<>B1+B2 and copy down.

 

[baldi]

thanks guys for the help. it works great

 

[mumps]

Glad to help.