Hi,

I'm using a conditional format 'if cell value' 'is equal to' 0, make
it red. It doesn't work. This is in the cell:

{=SUM(IF($E$6:$E$352=B399,($C$6:$C$352)))}

Any idea why? It turns red if it's not zero. The cell format is _(_
($* #,##0.00_)_);_(_($* (#,##0.00)_);_(_($* 0.00_)_);_(_(@_)_)

I'm having the same problem when I try to make a cell value red when
it's value does not equal the same value in another cell.

Any help would be appreciated.

Thanks,

Michele