Highlighting "Column A" if certain cells contain text

I've been trying for over a week to work out a formula/macro for this and finally given up!

I have a CD matrix that I use for work. The matrix includes a list of hard disk drive images and across the top has the CD numbers (Of my CD library e.g. CD33 Microsoft office v2) used to build the image.

Cd’s get updated all the time, when they do hard drive images must also be updated.

I want to have a cell that I type a CD number in, this will look for all images (marked with “x”) for the specified CD, and then highlight the CD image name.

I have attached a link to download an example of what I am trying to achieve.

http://rapidshare.com/files/12286448...ample.xls.html

Any help would be greatly appreciated.

Thanks,

James

Try this...

Using your posted workbook.
Select C4:DA7....with C4 as the active cell

From the Excel Main Menu:
<format><conditional formatting>
Condition_1: Formula is: =AND(C$2=$B$10,C4<>"")
Click the [Format] button and set the highlight color, etc.
Click the [OK] buttons until done.

Now if you enter a value in cell B10...
All cells under the matching CD number that ALSO are non-blank
will highlight.

Note: If you only want to hight cells containing an "X",
then use this formula: =AND(C$2=$B$10,C4="X")

Is that something you can work with?

Using your posted workbook....Try this:

Please Login or Register  to view this content.

Does that help?

I'm glad I could help.