I'm having issues coming up with a conditional format rule that highlights the top cell of a column based on if the bottom cell of that column has the greatest value in it's row.
This needs to be applied to 13 columns, so I want to highlight the top cell of the column that has the greatest value (based on the bottom row) of the 13 columns. I know I can do this via:
=AND($J$45>$L$45,$J$45>$M$45, $J$45>$N$45......etc etc applied to the top of the column. However, I would prefer not to do this for 13 columns 13 times. In the interest of expanding my knowledge, I wanted to find a simpler way. I thought of using the MAX function, but the bottom row of the column has formulas that result in a #DIV/0 error. Any way to do this?
Thanks!
Bookmarks