Remember Me?

#1
May 16th 05, 03:07 PM
 Yogi_Bear_79 Posts: n/a
Conditional Formatting Intermittent at best

I have a column in my spreadsheet tht uses conditional formatting. Each cell
in the column is idnetical in it's setup. The conditional formatting only
seems to work on about 75% of the cells.Any idea on how to force it to work
on all of them properly?

CONDITION 1
=(IF(ISERROR(DATEDIF(H10,NOW(),"d")),0,(DATEDIF(H1 0,NOW(),"d")))0)

Make the text RED

CONDITION 2
If the date is between =NOW()+60 and = NOW()+31
Make the text green

CONDITION 3
If the date is between = NOW()+30 and =NOW()+1 Make the text Orange

#2
May 16th 05, 03:09 PM
 Posts: n/a

Hi

Don't forget that the CF runs in the order that the conditions are input.
This means as soon as one of the conditions is met, the rest will be
ignored.

--
Andy.

"Yogi_Bear_79" wrote in message
...
I have a column in my spreadsheet tht uses conditional formatting. Each
cell
in the column is idnetical in it's setup. The conditional formatting only
seems to work on about 75% of the cells.Any idea on how to force it to
work
on all of them properly?

CONDITION 1
=(IF(ISERROR(DATEDIF(H10,NOW(),"d")),0,(DATEDIF(H1 0,NOW(),"d")))0)

Make the text RED

CONDITION 2
If the date is between =NOW()+60 and = NOW()+31
Make the text green

CONDITION 3
If the date is between = NOW()+30 and =NOW()+1 Make the text Orange

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

 Similar Threads Thread Thread Starter Forum Replies Last Post ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 01:08 AM BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM

All times are GMT +1. The time now is 09:27 PM.

The comments are property of their posters.