Forum Discussion
How define an Excel range in a conditional format with a range that increases
I have a spreadsheet with 1376 rows that is 6 years of daily data and with 2 columns: 1st=dates, 2nd=value. I want to do a conditional format that highlights the max value of the values for each yea...
A suggestion: Would it be possible to turn all data into an actual Excel table? If that is possible, you can give a name for a specific column of data in that table and then refer to that name in the conditional formatting. If the table increases in size, the name will still cover all rows or columns as you have set and consequently your formulation in the conditional formatting will take it into account.