Calculate Time Difference and Change Font Colour

[Guest]

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.

 

[Guest]

Use conditional formatting.

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

Dave

 

[Guest]

This has turned my whole cell red even though the number value is 0:30!! Any
ideas??

 

[SteveW]

I thought you said that the cell was in decimal hours is (a-b)*24
So why does it say 00:30 ?
Steve

 

[Guest]

Sorted....my fault thanks for the tip.

This has turned my whole cell red even though the number value is 0:30!! Any
ideas??