shades
Well-known Member
- Joined
- Mar 20, 2002
- Messages
- 1,550
I am using a spreadsheet with 15 columns (seven with numerical data, the others are company names, etc.) and 2500+ rows.
I have set up 11 buttons at the top of the spreadsheet for each of the regions (one of the columns). Also, I have included array formula to sum up the totals for the seven numerical columns. So each regional total for each of the seven categories can be seen.
I also have set up conditional formatting, so that when one of the buttons is selected, the corresponding region items will be highlighted in the table. However, I can get only the regional name to highlight, not the entire row.
Is there any way to highlight the entire row istead of just the one column with conditional formatting?
(I'm using Excel 97 - soon to be 2000.)
I have set up 11 buttons at the top of the spreadsheet for each of the regions (one of the columns). Also, I have included array formula to sum up the totals for the seven numerical columns. So each regional total for each of the seven categories can be seen.
I also have set up conditional formatting, so that when one of the buttons is selected, the corresponding region items will be highlighted in the table. However, I can get only the regional name to highlight, not the entire row.
Is there any way to highlight the entire row istead of just the one column with conditional formatting?
(I'm using Excel 97 - soon to be 2000.)