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

Change the colour of a cell if another named cell is blank 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Highlighting dates in a cell relative to the TODAY() 4
Adding cells until they are greater than a lookup cell and returning a value 1
Formula for Dates and CF Colour then convert to Text 3
Excel does not accept text format! 0
Conditional formatting from Dates 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top