I am attempting to use conditional formatting to highlight the second highest number in a row in Google Spreadsheets. I've set it to "format cells if custom formula is", applied to range "CO27:DB27" and I've tried the following;
=large(unique(CO$27:DB$27),2) =LARGE(CO27:DB27, 2) =INDEX(SORT(UNIQUE(CO27:DB27),1,FALSE),1,0)
These highlighted everything.
This highlighted everything BUT my second highest number and changing the
3 to a
4 then unhighlighted the cell next to it as well, which was not a high number at all. Since my highest number is in DB27,
3 un-highlighted it,
4 unhighlighted it and DB26.
This is what I'm using to highlight the highest.