Recolor Cell based on Sum of Zero

[Cloudburst99]

I have three cells. Value A, Value B, and a Sum or Total Cell, Value C. C is
calculated by adding/subtracting A & B. If the result in C is zero, I want
to format that cell so it is automatically recolored to yellow. How do I do
that?

 

[JulieD]

Hi

you'll need to use conditional formatting to do this
click on the C cell
and choose format / conditional formatting
choose
cell value is
choose
equal to
type a
0
click on format ... choose your formating, press OK twice

Cheers
JulieD