excel and conditional formatting

Computing.Net > Forums > Office Software > excel and conditional formatting

excel and conditional formatting

Original Message

Name: aparmar
Date: April 28, 2008 at 07:50:18 Pacific
Subject: excel and conditional formatting
OS: xp
CPU/Ram: 2gb
Model/Manufacturer: toshiba

Comment:

Dear All,
I have a small query on excel and conditional formatting. Here goes:
I have a column that has all dates in them displayed as 02.08.2008 or 15.09.2008.
My question is how do I format these cells so that if the date goes over lets say todays date it highlights the cell in a colour for example?
Any help would be great.
Thanks
Amit Parmar

Report Offensive Message For Removal

Response Number 1

Name: DerbyDad03
Date: April 28, 2008 at 09:23:17 Pacific
Subject: excel and conditional formatting

Reply: (edit)

Format...Conditional formatting
Choose "Formula is" from the drop down box and use this formula, assuming your date is in A1:
=IF(A1>TODAY(),TRUE,FALSE)
Then choose your formatting for when the result of the formula is TRUE and click OK twice.

Report Offensive Follow Up For Removal


excel question - conditional format Excel IF statements and conditional Number formatting - Excel and 123 Conditional formatting help conditional formating - excel	EXcel and SAP interface Excel and Powerpoint Excel and pictures Excel and a background Hide zero values in a Pivot Table

Encoding problems: GB2312

Delegate Rights

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: excel and conditional formatting

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

How often do you use Computing.Net?

Poll Finishes In 3 Days.
Discuss in The Lounge

Your computer has been infected

New PC.

Blank cd from unknown sender

Search a file name, Batch

dvr-ms being reported as wmv

All Posts Awaiting Replies