Quote:
Originally Posted by Pecoflyer
Hi and welcome to the board
Supposing your date is in A1 enter the following conditions for
RED : =A1<DATE(YEAR(TODAY())-4,MONTH(TODAY()),DAY(TODAY()))
GREEN =A1<>""
Cell will stay default color if empty
|
Sorry but could you tell me exactly where do I put that conditions?
Thx