I need to make an background for cell which contains date, if the range between dates is more than 100, then it should be colored as green if not the red.
I used New formatting rule with this formula: =IF(DAYS(F1;E1)>=100)
so if date range is more than 100 days, then it must be green other wise red. How can i do it?