***Date Warning***

HI
I've got a list of DATES (e.g. 02/02/06) in my spreadsheet, and
was wondering if it's possible to have some sort of WARNING displayed
in the same CELL (e.g.OVERDUE), once the DATE is equal to or
exceeded??

PLEASE HELP!!!!

Many Thanks


--
Stuck_At_Work
------------------------------------------------------------------------
Stuck_At_Work's Profile: http://www.excelforum.com/member.php...o&userid=30896
View this thread: http://www.excelforum.com/showthread...hreadid=505679

Hi,

Have you heard of conditional formatting?
This won't put a word in the cell but can be used to colur code overdue
items eg overdue by upto twenty days could be orange & anything greater
than twenty could be red. (Excel always for different formatting for up
to 3 conditions.)
To use conditional formatting select the first cell with the date in it
go to [format - conditional formatting - cell value is] ...
eg, I entered "greater than" & "=today()" & then selected the [format -
patterns] & selected red.

have a play & see if it helps,

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=505679

Thank You for your help, I'll have a plat and let you know!!!


--
Stuck_At_Work
------------------------------------------------------------------------
Stuck_At_Work's Profile: http://www.excelforum.com/member.php...o&userid=30896
View this thread: http://www.excelforum.com/showthread...hreadid=505679

Hi
I've had a try and for some reason and can't do it!! Is it
possible if you could tell me exactly (step-by-step)???

Many Thanks


--
Stuck_At_Work
------------------------------------------------------------------------
Stuck_At_Work's Profile: http://www.excelforum.com/member.php...o&userid=30896
View this thread: http://www.excelforum.com/showthread...hreadid=505679

Hi not sure how far you got so I've taken it from the start again...
TO CREATE THE FORMAT:
1) Select the first cell with the date in it.
2) go to the menu [format - conditional formatting].
3) choose "cell value is" from the first drop down box.
4) choose "greater than or equal to" from the second dropdown box.
5) & in the 3rd dropdown box type
=today()
exactly as it is with no apostrophe's.
6) then select the ["format" button - "patterns" tab] & select the red
colour.
7)click okay twice.

TO PASTE THE FORMAT:
8)copy this cell,
9) select all the cells with dates in,
10) go to the menu [edit - paste special] & paste special the
formulae.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=505679

SUPERB!!!

Really appreciate all your help, it worked!!! no longer stuck at
work, lol!!!



Kind Regards


--
Stuck_At_Work
------------------------------------------------------------------------
Stuck_At_Work's Profile: http://www.excelforum.com/member.php...o&userid=30896
View this thread: http://www.excelforum.com/showthread...hreadid=505679