Each range that I must apply conditional formatting to has 3 cells. For these 3 cells I am only counting the highest 2 values in my calculations. My goal is to visually depict the removal of the one lowest value by applying strikeout formatting on it. My conditional formatting works fine EXCEPT if there are duplicate values, then the conditional formatting applies to both (or all 3, if they're the same).
I need to somehow limit the conditional formatting to just one cell, even if there are more than one that fit its requirement in the range. Thanks for any help!
Bookmarks