Help with access 2007

Page may contain affiliate links. Please see terms for details.

davidjpowell

MB Enthusiast
Joined
Nov 8, 2007
Messages
4,923
Location
Doncaster
Car
E350 w212 and Ford Ranger
Hi

I am hoping that someone may be able to help me with an expression for Conditional Formatting. I have created a report and am trying to change the colour of a cell, dependent on the date inside the cell. I have found the right area to do this, but am having trouble with the criteria selection.

The field is called 'Break Date' and I want it to change colour if there is less than 365 days remaining. I think it should go something like Break Date-Date()<365 , but am really abit confused myself.

I would be grateful for any help from the IT wizards!

Kind regards

David
 

Users who are viewing this thread

Back
Top Bottom