Originally Posted by
Pete_UK
You can get the number of days remaining by using this formula:
=DATE(2013,11,1) - TODAY()
and formatting that cell as General.
Then you can apply conditional formatting to that cell - choose the option to "Use a formula ... etc." and then set up 4 different conditions as follows:
=cell<=30 format Green
=AND(cell<=60,cell>30) format Yellow
=AND(cell<=90,cell>60) format Orange
=cell>90 format RED
you need to put the appropriate cell reference in the formulae instead of cell.
Hope this helps.
Pete
Bookmarks