CHANGE COLOUR(CELL) FOR MANY DATES IF ARE SMALLER THAN ONE DATE
A HAVE A TABLE WITH MANY DATES AND I WANT TO CHANGE COLOUR CELL IF DATES ARE
SMALLER OR BIGGER THAN ONE DATE
EXAMPLE:
DATES
12.02.2006
12.03.2008
12.02.2010
13.12.2011
28.07.2003
+.................
AND REFERENCE DATE IS 01.11.2008
CELLS WITH DATE SMALLER THAN 01.11.2009 ---RED
AND CELLS WITH DATE BIGGER THAN 01.11.2009--- BLUE
MANY THANKS !!!!!!!!!!!!
|