Forum Discussion
Conditional Formatting not showing colours correctly
Hmmm okay, try changing the green row to :
> 1 Number and <= 100 Percent
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Ah yeah change the green value to > 99 and <= 100
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you that seemed to have worked. However one more issue is that some of my figures are greater thenat 100% as they have over performed. I cannot seem to say if its over 100% then it needs to be green?
Hmmm okay, try changing the green row to :
> 1 Number and <= 100 Percent
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Boom! It worked thank you! I had to change the order of the rules but that is all sored now thank you so much!
No worries, happy to help 🙂