davidjpowell
MB Enthusiast
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
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