Conditional formatting

[John thomas]

Hi .
This is my first attempt at conditional formatting .
I have a report With a date for work to be undertaken .
AS time gets near i would like to highlight this date with 2 weeks to go
and then highlight again diffrent colour 1 wek to go
Is this possible

 

[Big Pat]

Use the conditional formatting button and change the dropdown from 'Field Value Is' to 'Expression Is'. Then enter the formula DateDiff("d",Date(),[WorkDeadline])<=7 and set your required formatting e.g. red text or red shading.

Next add another condition, select 'Expression Is' again. Paste in the same expression but change 7 to 14. Set formatting for this condition e.g. orange shading.

 

[John thomas]

Hi big pat .That terrific .Thanks very much