Conditional Formatting basic question

{MC} · Mar 16th, 2002, 05:39 PM

Hi, my knowledge of excel is nowhere near where most of you are and I have a question about conditional formatting.

Lets say I have a cell with a date in it and if that date has passed I would like the cell to change to red. So I highlighted the date cells and selected conditional formatting, I filled in the dialog box so it was cell value is less than today() but no matter what date I put in there it changes to red.

I tried finding the answer myself but had no luck. Thanks

smozgur · Mar 16th, 2002, 05:45 PM

Just create this condition in order:

Cell Value is - less than - =TODAY()

and set your format..

If you want to use a specific day as criteria then

Change

=TODAY()

to

=DATEVALUE("12/12/2001")

"12/12/2001" is my criteria.

Enjoy
suat

[ This Message was edited by: smozgur on 2002-03-16 16:48 ]

Dave Hawley · Mar 16th, 2002, 07:09 PM

Hi

Looks like you have your answer, but in addition you might be interested in an example Workbook download I have here:

http://www.ozgrid.com/download/default.htm It's the second from the bottom (OverDueDates.zip)

{MC} · Mar 16th, 2002, 08:19 PM

Thanks for the help!

smozgur · Mar 16th, 2002, 08:41 PM

Anytime.

suat

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 16th, 2002, 05:39 PM	#1
{MC} New Member Join Date: Mar 2002 Posts: 2	Hi, my knowledge of excel is nowhere near where most of you are and I have a question about conditional formatting. Lets say I have a cell with a date in it and if that date has passed I would like the cell to change to red. So I highlighted the date cells and selected conditional formatting, I filled in the dialog box so it was cell value is less than today() but no matter what date I put in there it changes to red. I tried finding the answer myself but had no luck. Thanks

Mar 16th, 2002, 05:45 PM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Just create this condition in order: Cell Value is - less than - =TODAY() and set your format.. If you want to use a specific day as criteria then Change =TODAY() to =DATEVALUE("12/12/2001") "12/12/2001" is my criteria. Enjoy suat [ This Message was edited by: smozgur on 2002-03-16 16:48 ]

Mar 16th, 2002, 07:09 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Looks like you have your answer, but in addition you might be interested in an example Workbook download I have here: http://www.ozgrid.com/download/default.htm It's the second from the bottom (OverDueDates.zip)

Mar 16th, 2002, 08:19 PM	#4
{MC} New Member Join Date: Mar 2002 Posts: 2	Thanks for the help!

Mar 16th, 2002, 08:41 PM	#5
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Anytime. suat