Forum Discussion

László's avatar
László
New Member
2 years ago
Solved

Conditional formatting in table

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

Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    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

2 Replies

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    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