Forum Discussion

kellyylx's avatar
kellyylx
Helper I
2 years ago
Solved

Highlight cell based on another column

Hi, I have this table below and I want to highlight all records that belongs to an odd-numbered group    name address   Group A Currie Street  1 B Mary Road Block 4     0 C Stadi...
Need Help
  • muhammad_786_1's avatar
    muhammad_786_1
    2 years ago

    Hi kellyylx 

     

    Thank you aduguid  for your solution! 

     

    I'd like to provide an additional approach, if you're not sure how many odd values you have, you can create a calculated column using this DAX formula:

     

     

    Then, you can apply a rule based on the "Odd" value in this new column to achieve the desired conditional formatting. This way, you can dynamically manage any changes in the "Group" values and ensure your formatting rules are always accurate.

     

    Best Regards,
    Muhammad Yousaf

     

    If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

     

    LinkedIn

     

muhammad_786_1's avatar
muhammad_786_1
Solution Supplier
2 years ago

Hi kellyylx 

 

Thank you aduguid  for your solution! 

 

I'd like to provide an additional approach, if you're not sure how many odd values you have, you can create a calculated column using this DAX formula:

 

 

Then, you can apply a rule based on the "Odd" value in this new column to achieve the desired conditional formatting. This way, you can dynamically manage any changes in the "Group" values and ensure your formatting rules are always accurate.

 

Best Regards,
Muhammad Yousaf

 

If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly.

 

LinkedIn