Conditional Formatting

[shades]

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.)

 

[shades]

Great! Because I was trying to reference two different cells for formatting, it wouldn't work. But I tried the Index Function as you suggested and set up a separate reference cell. Worked like a charm!!

Thanks for the help, Mark!!!