cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
karlagb20 Member
Member

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 "greather than > 20" because right now the highest is over 20 but if any of the other go over 20 then they will get a background color and I dont want that. and If I do the range then it shows like the middle one and I want only the top one to get highlighted. Maybe an IF statement ike (IF[ProjectITStaff]=MAXVALUE,1,2) I could use the 1 and 2 in the conditional formatting as stable numbers. I can't figure out the IF statementConditionl.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-cherch-msft
Microsoft

Re: Conditional Formatting Highest Value

Hi @karlagb20 

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

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Microsoft v-cherch-msft
Microsoft

Re: Conditional Formatting Highest Value

Hi @karlagb20 

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)

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
karlagb20 Member
Member

Re: Conditional Formatting Highest Value

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

Microsoft v-cherch-msft
Microsoft

Re: Conditional Formatting Highest Value

Hi @karlagb20 

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

a1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,681)