View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Snidow Greg Snidow is offline
external usenet poster
 
Posts: 153
Default Conditional formating not working

Greetings all. I have a formula in E3, =SUM(D6:F6). I have a formula in E4
which is to sum three other cells. In E5 I have formula =E4-E5. I have
conditional formating on E5 as cell value is equal to 0, change background
color to green. If the value of E5 is 0, based on the formula in it, the
conditional formatting does not work. However, if I manually type in 0, then
it turns green. Does anyone know why this would be happening? All cell
involved are formattted as number with no decimals.

Greg