Excel conditional formatting

Closed
Danieeeella Posts 2 Registration date Tuesday January 12, 2016 Status Member Last seen January 12, 2016 - Jan 12, 2016 at 05:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 14, 2016 at 11:08 AM
Hi All,

I need your help with conditional formatting please?

I've a project timeline on a week and month calendar form. I've applied conditional formatting on a row range (blank cells on the calendar), based on inputting of a start and and date of a given task.
I also need to apply conditional formatting on those same row range (blank cells on the calendar), when selecting a certain resource drop down list. So to summarise:

I need conditional formatting applied on a row range based on dates.
I need conditional formatting applied on the same row range based on a criteria.

How do I do that?

Thanks a million!!!
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 12, 2016 at 11:23 AM
Hi Danieeeella,

Why don't you add another rule? Can't give any further advise since I don't know the rule based on date nor the rule based on a criteria.

Best regards,
Trowa
0
Danieeeella Posts 2 Registration date Tuesday January 12, 2016 Status Member Last seen January 12, 2016
Jan 12, 2016 at 12:28 PM
Hi Trowa, thanks for replying.

I thought about that but they kinda clash and excel is choosing on over the other.
The rule based on date is: =AND($D18<I$14,$E18>=H$14) and a rule based on a criteria(text) is the one I'm looking for.

Thanks
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 14, 2016 at 11:08 AM
Hi Danieeeella,

Then check the order of your rules. The first rule is prioritised over the second one.

For example:
1ste rule: =B1=1 ; Green
2nd rule: =B2=1 ; Red

When you enter 1 in B1, the cell changes Green. When you enter 1 in B2 then the cell stays Green.
BUT when you enter 1 in B2, the cell changes Red. When you enter 1 in B1, then the cell changes to Green.

This assuming you want 2 different formats for your rules.

Hopefully this helps a bit.

Best regards,
Trowa
0