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

Try this: In a couple of other cells in the workbook, assign them to be the
values in G3 and H3 (if I remember them correctly). Then format these cells
as NUMBER and change the number of decimal places until you see if there is
really a difference.

"changetires" wrote:


the answers are in HH:MM format when the times are equal then they will
display the color red. Some cells work fine the the conditions but some
cells will show red


Ed


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