conditional formatting

rickf2220 · Mar 21st, 2002, 10:37 AM

question: I have 20 columns of data, in one of the columns I have a row of dates: example: 1/31/02, what i would like to do is compare the date against today, if its less than or equal to todays date I would like the row of data to turn red. Any help would be appreciated.

Aladin Akyurek · Mar 21st, 2002, 10:45 AM

Quote:

On 2002-03-21 09:37, rickf2220 wrote:
question: I have 20 columns of data, in one of the columns I have a row of dates: example: 1/31/02, what i would like to do is compare the date against today, if its less than or equal to todays date I would like the row of data to turn red. Any help would be appreciated.

Lets say that that column where you have dates is C and that your data start start in row 1.

Select all of the cells of your data range.
Activate Format|Conditional Formatting.
Choose Formula Is for Condition 1.
Enter in the formula box:

=$C1<=TODAY()

Activate Format.
Select a color on the Patterns tab.
Click OK, OK.

rickf2220 · Mar 21st, 2002, 11:06 AM

That worked, thanks for your help.

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

Mar 21st, 2002, 10:37 AM	#1
rickf2220 New Member Join Date: Mar 2002 Posts: 2	question: I have 20 columns of data, in one of the columns I have a row of dates: example: 1/31/02, what i would like to do is compare the date against today, if its less than or equal to todays date I would like the row of data to turn red. Any help would be appreciated.

Mar 21st, 2002, 11:06 AM	#3
rickf2220 New Member Join Date: Mar 2002 Posts: 2	That worked, thanks for your help.