Previous Topic Next Topic

Conditional formatting where 2 statements are met

Closed
mp673uk Posts 1 Registration date Friday 24 July 2015 Status Member Last seen 24 July 2015 - 24 Jul 2015 à 09:20
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 28 Jul 2015 à 11:56
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Jul 2015 à 11:56
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