Conditional Format multiple cells

[John Gorman]

Looking at Contexture, I think I'm close, but....
Have a header row of 25 items and in A1 I want to put a list with 4
selections
Depending on what item is selected from the list I want to highlight certain
columns headings.
ie; If I select Text A it will highlight columns D,E,F, J,K, N, P; If I
select Text C it will highlight columns B,C, D,F, J,K, N
Basically, if it's this then complete these highlighted columns, if its
something else, complete those highlighted columns, etc.

Probably simple and I'm just too tired to think tonight. Thanks for any
help.

 

[Debra Dalgleish]

You can mark the columns on another sheet, and refer to that in the
conditional formatting. I've added a sample to my web site:

http://www.contextures.com/excelfiles.html

Under Conditional Formatting, look for 'Highlight Column Headings'

 

[John Gorman]

Deb, many thanks.
I found Conditional Formatting, and 'Highlight Column Headings' , but when I
selected the link I received a page cannot be found. Maybe temporary?
I'll try again later perhaps.

 

[Debra Dalgleish]

Sorry John -- I forgot to upload the file! It's fixed now.

 

[John Gorman]

Deb, got it! Does exactly what I need.
Thanks so much for such a quick response.
Hope I can return the favor someday.

Have a great day!