LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default Calculate Time Difference and Change Font Colour

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Averaging Time Difference vldavis809 Excel Discussion (Misc queries) 1 July 8th 06 09:42 AM
Capturing The First Change in a Formula carl Excel Worksheet Functions 9 February 17th 06 10:37 PM
Change over time fornula Trevor Excel Worksheet Functions 4 January 4th 06 10:05 PM
Cell formats, and time difference Peter Kirk Excel Discussion (Misc queries) 1 May 25th 05 10:41 PM
calculate negative or positve difference in time kpmoore Excel Discussion (Misc queries) 2 January 5th 05 01:35 AM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"