View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Conditional Formatting

Can you post the formula for the condition? Also, is it possible that H36 =
3.000001 and G36 = 3.00000?

"changetires" wrote:


Why does my cell turn red when the conditions are either not met.
Example, Cell t51 conditions are (turn the cell red when cell h36 is
greater than G36. If my answer in cell h36 is equal to g36 the cell is
still turning red although you can clearly see that they are just
equal.

Whats the problem?


ED


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=564803