Forum Discussion
AdministratorConditional Formatting Background Color
Hello
Can anyone help me with conditional formats? I've tried a lot of variations and I can't get him to paint cell 2.77 or 8.28 green. The rest if he paints it well.
Thank you.
You need to change the value 0.1 in your Green Rule to 0 instead.
When 2.77% and 8.28% are translated to decimal numbers, they will become 0.0277 and 0.0828 respectively. Both fall in the interval between 0 and 0.1, which your rules are currently not coloring.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.Hi apenaranda ,
Jonvoge Good Answer!
And you can also change here into "Percent":Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Jonvoge
Most Valuable Professional
You need to change the value 0.1 in your Green Rule to 0 instead.
When 2.77% and 8.28% are translated to decimal numbers, they will become 0.0277 and 0.0828 respectively. Both fall in the interval between 0 and 0.1, which your rules are currently not coloring.
_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'. Hi apenaranda ,
Jonvoge Good Answer!
And you can also change here into "Percent":Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.