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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 14, 2016 at 11:08 AM
Related:
- Excel conditional formatting
- Excel date format dd.mm.yyyy - Guide
- Marksheet format in excel - Guide
- Clear formatting in excel - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
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
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
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
Jan 12, 2016 at 12:28 PM
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
Jan 14, 2016 at 11:08 AM
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