I can apply conditional formating to a row and get what I want but I can’t do it manually for a large table with 50+ rows.
If I use Paste Special and select only Formats I get several cells in the same row highlighted at once, seemingly at random.
If I select the whole area for conditional formatting, how can I modify the formula to calculate values only from each cell’s row? Let’s say I start with this in conditional formatting dialogue: MAX(A1:E1), how to change it to something like MAX(A’value of this row’:E’value of this row’) so that for cell F3, for example, conditional formatting calculates MAX(A3:E3)?
=RIGHT(ADDRESS(ROW(),COLUMN(),4,1),LEN(ROW())) gives me the row number, but how to incorporate it into formula for MAX?
Or maybe there’s another solution,