Forum Discussion
Virtual_Ames
Microsoft Employee
Microsoft EmployeeConditional Formatting - how to keep context with slicer?
I am using the new conditional formatting for tables feature - looks great. And.... I want to be able to use this with a slicer, which presents a challenge. In the initial "unfiltered" s...
Virtual_Ames In conditional formatting if instead of using Lowest Value and Highest Value, you use Number to set colours for both Minimum and Maximum, it will work when you filter out one project using slicer.
ankitpatira
Community Champion
Community ChampionVirtual_Ames In conditional formatting if instead of using Lowest Value and Highest Value, you use Number to set colours for both Minimum and Maximum, it will work when you filter out one project using slicer.
Virtual_AmesMicrosoft Employee
Microsoft EmployeeThanks - this does this trick. Have a good one.