| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Time Difference and Change Font Colour
This has turned my whole cell red even though the number value is 0:30!! Any
ideas?? "Dave F" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Time Difference and Change Font Colour
I thought you said that the cell was in decimal hours is (a-b)*24
So why does it say 00:30 ? Steve On Thu, 01 Feb 2007 16:23:02 -0000, AndyO_UK wrote: This has turned my whole cell red even though the number value is 0:30!! Any ideas?? "Dave F" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate Time Difference and Change Font Colour
Sorted....my fault :-) thanks for the tip.
"AndyO_UK" wrote: This has turned my whole cell red even though the number value is 0:30!! Any ideas?? "Dave F" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging Time Difference | Excel Discussion (Misc queries) | |||
| Capturing The First Change in a Formula | Excel Worksheet Functions | |||
| Change over time fornula | Excel Worksheet Functions | |||
| Cell formats, and time difference | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Linear Mode
