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
Hello,

I'm trying to use conditional formatting in excel 2010 where if the data in column D is 'In Progress' and the data in column N is a % between 0.01 and 20 then it highlights the data in column N orange to highlight that the budget is getting close to being used up.

Can't quite work it out....any idea's?
Related:

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
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