Hello,

My manager reviewed some of my work in Excel.

In order to highlight rows in a certain color, he clicked on the row # so the entire thing was selected. After that, he would change the highlighted color to Red or Green.

The problem is that the table is only about 6 columns; however the new highlights extend passed these 6 columns infinitely.

Is there a way to remove his highlights beyond column 6? If I delete these columns, more just re-appear from the right. If I select, for example, columns 7-14 (the visible columns) and remove the highlight, columns 15 - infinity will still be colored.

Anyone have any suggestions with this problem? I would really appreciate it!

Thanks,
Nick