CHANGE COLOUR(CELL) FOR MANY DATES IF ARE SMALLER THAN ONE DATE

S

SACKYROF

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 !!!!!!!!!!!!
 
A

Ashish Mathur

Hi,

For me since these were not dates (because of the period symbol), I replaces
all periods to / with Ctrl+h. This converted all the values to dates.
Then, I just used condition fomratting. While on the cell value is option,
I selected "less than" 11/01/2009. Then I clicked on Add and selected
"greater than" 11/01/2009. Select the format for each of these conditions
by clicking on the Format button.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with date formula and colour change 3
Conditional formatting from Dates 3
Formula for Dates and CF Colour then convert to Text 3
Highlighting dates in a cell relative to the TODAY() 3
countifs Function not giving desired result with date criteria 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
change cell colour according to date..... 2
Excel 2003 make 1 date cell automatically change another date cell 3

Top