Thread: Conditional Formatting

Hello,

I have a spreadsheet with rows 000-999 representing my master list of products.

Columns A-I are for descriptions, codes, specs, etc for each item.

Columns J-T are all the Brands I represent which may use any one or more of the 1000 products.

If a Brand uses a particular product then I currently have an 'x' in the cell under its column and next to the respective product 000-999. If the Brand doesn't use it the cell is left blank.

I want to distribute a locked spreadsheet to my operators as an easy reference of what products they are authorized to buy for their Brand.

I need a way to set a link or button or drop-down or trigger somewhere at the top of the page whereby selecting 1 of 8 options will have excel go down each row and highlight only the rows adjacent to all the 'x' for that Brand. I am ok with a row of 8 buttons, or even using the Brand column header as the button.

Example:

If I trigger Brand ABC then rows 007, 012 and 013 are highlighted blue because those rows are marked 'x' for ABC..

If I trigger Brand XYZ then rows 007, 012, 044, 301, 315 are highlighted green because those rows are marked 'x' for XYZ.

etc.

** It is important to note, whenever I trigger ABC, it will clear any previous highlights first. I don't want to confuse things with 8 different colors overlapping. I only want to highlight what is relevant to that Brand.

Is this even possible?

Thanks
-Peter

Hello and welcome to the forum,
Please supply a sample workbook so others will understand your layout.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Here is a simple visual example of what I am trying to do using macros.

CLICK HERE:Macro Forum Example.pdf
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!