Forum Discussion
Stop conditional formatting at the end of the data
I have conditional formatting on a data set from a power query. Part of the conditional formating is "if a cell is blank" formating. I have this selected for the entire column. Is there a way to stop...
Theoretically you should not have to format the entire column, just format the data area of the table. Excel should automatically expand and contract the formatting with the size of your table.