Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting

Conditional formatting

ResolvedVersion 2010

Jay has attended:
Excel Intermediate course
Excel Advanced course

Conditional formatting

Hi,

I think i spoke to doug before about this matter but i need a step further. i have the code, which is: =AND($I2>0,$I2<=TODAY()+7)

for the selected area, this would highlight the row if the date from Today was 7 days away (1 week).

I now need to include if its 1 month away (30 days) so if it was a week it would go one color but if its 1 month away it would go another?

I think i need to add to this code with an IF function but not sure how to go about it?

regards

Jay

RE: Conditional formatting

Hi Jay

To have Conditional Formatting display one colour for a month away and another colour for a week away I think you would need to create 2 separate rules.

Rule 1
=AND($I2>0,$I2<=TODAY()+7)

Rule 2
=AND($I2>0,$I2<=TODAY()+30)

Note that the rule for a week away must be the first condition. To check or change the order use Manage Rules and the arrow button to move up or down a condition.

Thanks for the question

Doug
Best STL

RE: Conditional formatting

Thanks i did do this, just didn't know that one had to be first.

thanks

RE: Conditional formatting

Thanks i did do this, just didn't know that one had to be first.

thanks

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.