Conditional formatting in table

[László]

Hello,

I would like to conditional format values based on if the rolled sum of values <= than another value in the table

My table looks like this:

I want it to look like this:

Is this possible?

Thank you in advance

[László]

Thank you, I was hoping it could work, but oh well...

[JoeBarry · Accepted solution]

Hi @László 

This way to my knowledge isn't possible . Move the Készlet from columns to Rows. Then the values will be the only column. highlight the visual and go to Format > Conditional Formatting. Then go to Rules and make sure that the Rules are based on the Values. Then add your rules.

Thanks

Joe

If this post helps, then please Accept it as the solution