I have a spreadsheet for a game that I play (EvE Online), and this is the table I use:
I'd like to know how can I make conditional formatting to highlight the MAX value comparing columns I (corp total) and column M (market total) for each line, my goal is to have these values highlighted as an example:
=QUERY(TRANSPOSE(QUERY(TRANSPOSE($I1:M),"select
"®EXREPLACE(JOIN(,ARRAYFORMULA(IF(LEN(I1:I),"max(Col"&ROW(I1:I)-
ROW(I1)+1&"),",""))),".\z",""))),"select Col2")