View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Calculate Time Difference and Change Font Colour

Use conditional formatting.

Via Format--Conditional formatting. When the cell value is 2, format the
font red.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"AndyO_UK" wrote:

Hi

I have the following setup in my spreadsheet =(H3-C3)*24 and require this to
change the font RED when the calculation exceeds 2 hours.

Grateful of your help.