Recolor Cell based on Sum of Zero
 

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?

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

"Cloudburst99" wrote in message
...
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?