Forum Discussion
Conditional formatting background color according to %
Hello
Can someone explain why I color the first four and not the fifth (7.57%)?
Another thing I do not understand is why it marks the first two if in the rule I have between 7% and 100% since it does not let me put between 7% and 500%
And last question is how to paint the whole row. Is it possible?
5 Replies
pls try this
7% = 0.07
100% = 1Thanks a lot!
And painting the entire row could be?
Well, not only paint the column where I have assigned the conditional, but also paint the other columns of that same row.
Thanks a lot!
