Forum Discussion

haranp12's avatar
haranp12
Copper Contributor
Jun 10, 2023
Solved

Excel conditional formatting not working

Hi

I am trying to get the conditional formatting to work for my budget. The rules I want is 

if I am under budget (less than 0) , it should be green

If I am over budget but less than 10, it should be amber

If I am over budget by more than 10, it should be red. 

I have set the conditional formatting rules like this

But it is not working for amber. There is 1 line item where the the budget was exceeded by 28%. But it is not red. it is amber

 

i am using 

 

All suggestions are appreciated

  • haranp12 you are obviously working with percentages, but in the CF rules you mention whole numbers. Change 10 to 0.1 and it shall work.

2 Replies

Resources