Posted to microsoft.public.excel.worksheet.functions

Financial Admin

Posts: n/a

Conditional Formatting not giving correct answer...

I am using conditional formatting to set a function that will format a date
if it's above 30 days old.

Ex. - If the date (12/20/05) is over 30 days (1/6/06), turn it orange.

Formula is - (cell for 12/20/05 - cell for 1/6/06) 30

It turned orange! any reasons why???
Help I dont want to use this conditional formatting if its gonna give back
incorrect results? Could it be the year 2006 throwing it off?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cannot use ISEVEN or ISODD functions in Conditional Formatting	Scott Paine	Excel Worksheet Functions	6	December 6th 05 09:44 PM
... Can I Copy Conditional Formatting...	Dr. Darrell	Excel Discussion (Misc queries)	1	December 1st 05 01:58 PM
conditional formatting on a PivotTable?	confused	Charts and Charting in Excel	0	June 13th 05 04:15 PM
Conditional Formatting Error	ddate	Excel Worksheet Functions	0	May 5th 05 09:00 PM
Conditional Formatting	Graham Warren	Excel Worksheet Functions	0	November 7th 04 04:58 PM

All times are GMT +1. The time now is 04:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us