I am working in a spreadsheet analyzing rainfall data. This sheet has 50,000+ rows, and ~35 columns.
About half of the columns are formulaic, and are conditionally formatted to highlight based on Min>>Max.
As you travel down a column, you may come across anywhere from 3-300 contiguous cells that are displaying a result, while the IF function in the rest has left them blank.
Currently, every cell in all 50,000+ rows of each column is highlighting on the same scale. Is there anyway to automatically parse the highlight so that each contiguous group of cells in each column has only it's own Max highlighted?
Certainly, this is possible manually, but that is completely absurd to think of doing.
About half of the columns are formulaic, and are conditionally formatted to highlight based on Min>>Max.
As you travel down a column, you may come across anywhere from 3-300 contiguous cells that are displaying a result, while the IF function in the rest has left them blank.
Currently, every cell in all 50,000+ rows of each column is highlighting on the same scale. Is there anyway to automatically parse the highlight so that each contiguous group of cells in each column has only it's own Max highlighted?
Certainly, this is possible manually, but that is completely absurd to think of doing.