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.

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.

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.

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.

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.