I have a table that is five cells wide by twenty high with a sum function at the end (e.g. cel A20). I want to highlight the column that results in the highest SUM. How do I use conditional formatting with the formula condition IF A20=MAX(A20:E20) THEN Highlight A1:A20?
That works pretty much exactly as you noted: