View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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?