Hello all.
I have been trying to condition cells using the TODAY() approach.
My Spreadsheet is required to highlight cells in 3 seperate coluors based on the date entered and the actual date.
Im trying to condition the cells to achieve the following.
- If the date entered is 11 months ago or longer i need the cell to go RED.
- If the date entered is between 8 months and 10 months ago i need i need the cell to go ORANGE
- If the date entered is less than 8 months ago i need teh cell to be GREEN
When using the TODAY() function i cant seem to get my head around wether i should be using between, less than, greater than etc.
Any help would be greatly appriciated.
Cheers Kev
Bookmarks