I am trying to apply a conditional format to a range of weeks, I want the week with the greatest build percent highlighted:
store wk1 wk2 wk3
1 -32% 50% 75%
2 -20%30% 40%
I would like store 1's week 3 highlighted and store 2's week 3 highlighted because these weeks represent the highest percent build.
Can I use a conditional format or is there another way to highlight the greatest value?
Bookmarks