Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in a report with the format of "hh:nn". I am trying to apply conditional formatting to it, so when the time is greater the 03:30 hours it turns red.
I am unable to apply any formatting of any sort. If I use the format 03:30 in the contditional formatting dilog box I get an error of "The expression you entered contains invalid synta

Please has anyone got any suggestions

thanks
 
Hi

A Time field is stored as a double representing a number
of days, so you need a condition like >
3.5/24
This would highlight all after 03:30 as you require.

hth

Chris

-----Original Message-----
I have a field in a report with the format of "hh:nn". I
Click to expand...
am trying to apply conditional formatting to it, so when
the time is greater the 03:30 hours it turns red.
I am unable to apply any formatting of any sort. If I use
Click to expand...
the format 03:30 in the contditional formatting dilog box
I get an error of "The expression you entered contains
invalid syntax
 
Thanks Chris I will try that

Shane
Chris Large said:
Hi

A Time field is stored as a double representing a number
of days, so you need a condition like >
3.5/24
This would highlight all after 03:30 as you require.

hth

Chris


am trying to apply conditional formatting to it, so when
the time is greater the 03:30 hours it turns red.
the format 03:30 in the contditional formatting dilog box
I get an error of "The expression you entered contains
invalid syntax
Click to expand...
 
Tried that Chris. It highlites everything from 00:13 to 09:59

Any other ideas?

Cheers

Shane
 
Back
Top