RichCowell
Board Regular
- Joined
- Dec 5, 2013
- Messages
- 121
- Office Version
- 365
- Platform
- Windows
Hi all,
I've got a spreadsheet with dates in two columns, the date in the second column is calculated automatically based on the date in the first column.
I need to apply Conditional Formatting to the cells in the second column so if the difference between that cell and today's date is greater than 90, make it green, between 1-90 orange, and 0 or under red.
Just concentrating on the first part initially, I've got the following formula for anything above 90, however, it doesn't change the formatting:
="(Value(M6)-Value(TODAY())>90)"
(M6 is in the second column, and is the top of the dates)
Can anyone point me in the right direction?
I've got a spreadsheet with dates in two columns, the date in the second column is calculated automatically based on the date in the first column.
I need to apply Conditional Formatting to the cells in the second column so if the difference between that cell and today's date is greater than 90, make it green, between 1-90 orange, and 0 or under red.
Just concentrating on the first part initially, I've got the following formula for anything above 90, however, it doesn't change the formatting:
="(Value(M6)-Value(TODAY())>90)"
(M6 is in the second column, and is the top of the dates)
Can anyone point me in the right direction?
Last edited: