I am looking to conditionally format each row of items to find the lowest value, leave that value with no color, and turn the other 2 values another color. As to make it obvious which value is the lowest.
Also, if a value is duplicated AND it's the lowest than both would format to no color and the third value would turn the other color.
Simple idea, and I come close to figuring this out, just need a little "aha" moment.
Thanks for the help,
Adam
Bookmarks