How do I compare a row of 30 cells with a value in each to compare and high light the highest. Some will have 0 in them.
Posted on 2014-09-02
I need to compare multiple cells in a row. These cells have numbers in them, and I want either a macro or something that looks at the cell values in the row and flags the cell with the highest value.
I tried the formula =B2=MAX(B2:AE2) It has came back with a true / false answer. I need to have the highest value highlighted as previous asked by Rugoingwme. I can't find conditional formatting on my MS Office Ultimate 2007 either. Is this why I can't get the result I'm after? Would appreciate some helpful advise.