Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional Formatting Highest Value

Hi,   Is there a way I can do a rule or something in the conditional formatting to add a background color for the highest number without typing the number?    For example, Right now Im doing "gre...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may use the IF measure in conditional formatting as below for each column.

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

You may create measures as below:

Sum_Pro = CALCULATE(SUM(Data[ProjectITStaff]),ALLEXCEPT(Data,Data[Active]))
IF = IF(SUM(Data[ProjectITStaff])=MAXX(ALL(Data),[Sum_Pro]),1,2)

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-cherch-msft I want for it to highlight the "Global" row. So the highest number in the global row, not the column header

    • v-cherch-msft's avatar
      v-cherch-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous 

      You may use the IF measure in conditional formatting as below for each column.

      Regards,