Forum Discussion

Helper III

3 years ago

Solved

Color Formatting Table Entire row

Hi, I need to do conditional coloring based on the sales stage. For example, final committee review and due diligence will be red, term sheet negotiation will be yellow, and collecting informati...

Samarth_18

3 years ago

Hi rwong1 ,

Create a measure as below and use it conditional formating for all the columns.

_conditional_color = SWITCH(TRUE(),
MAX('Table'[Sales Stage]) = "Due Diligence","red",
MAX('Table'[Sales Stage]) = "Term Sheet Negotiation","Yellow",
MAX('Table'[Sales Stage]) = "Collecting Information","Green")