Multiple Color Conditions

The code below works perfect except I want to highlight other cells in the same row where the text in column D equals one of the item#s (eg, Item1, Item2, etc). So for example, at this point, if cell D10 equals Item4, then it will be color shaded whatever # 36 is on the Excel pallette. I want that to happen but to also have A10, B10, C10, E10, F10, - L10 shaded the same color (#36). Is there a simple code change I can make?

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

This did not work. I changed the line below to check and see if this worked too but nothing...ANY idea why it is not working?

For Each oCell In Range("D3:D50")

For Each oCell In Range("D3:L50")

It works for me.

Add a formlua to any cell, or change the value in the demo workbook cell A3.

Perhaps you need the code in the sheets' change event if D3:D50 is not formula derived.