Conditional formatting background color according to %

Question

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?

ahmedx · Answer

pls try this7% = 0.07100% = 1

syndicate_admin · Answer

Thanks a lot!And painting the entire row could be?

syndicate_admin · Answer

Well, not only paint the column where I have assigned the conditional, but also paint the other columns of that same row.

ahmedx · Answer

Yes! you can do it. watch my videohttps://1drv.ms/v/s!AiUZ0Ws7G26RiSXtgUHIYjD60LD3?e=Btjna5&nbsp;&nbsp;

syndicate_admin · Answer

Thanks a lot!

Forum Discussion

Conditional formatting background color according to %

5 Replies

Related content

Background Colour - conditional formatting

Conditional Formatting using DAX

Conditional Formatting

Matrix Row Conditional Formatting

Conditional Formatting