Conditional formatting where 2 statements are met
Closed
mp673uk
Posts
1
Registration date
Friday July 24, 2015
Status
Member
Last seen
July 24, 2015
-
Jul 24, 2015 at 09:20 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 28, 2015 at 11:56 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 28, 2015 at 11:56 AM
Related:
- Conditional formatting where 2 statements are met
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Plants vs zombies 2 pc download - Download - Strategy
- How many if statements can you nest - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 28, 2015 at 11:56 AM
Jul 28, 2015 at 11:56 AM
Hi mp,
Try this:
=AND($D2="In Progress",$N2>=0.01,$N2<=20)
Or if you have you percentage column like 0.01% and 20% then try this:
=AND($D2="In Progress",$N2>=0.0001,$N2<=0.2)
Best regards,
Trowa
Try this:
=AND($D2="In Progress",$N2>=0.01,$N2<=20)
Or if you have you percentage column like 0.01% and 20% then try this:
=AND($D2="In Progress",$N2>=0.0001,$N2<=0.2)
Best regards,
Trowa
