Forum Discussion
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
- Riny_van_EekelenPlatinum Contributor
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.
- haranp12Copper Contributor
Riny_van_Eekelen Thanks a lot. Your suggestion worked