How can I use conditional formatting to apply different fill color for products?-CodePudding

I am trying to find a way to apply different fill color for products according to produc type. Thank you for your help.

CodePudding user response：

You can use Conditional formatting under Format menu and using the custom formula:

=C1="BM"

Sample:

and do it for each color and product type you need.

Output:

EDIT:

If the product type is in different sheet Type

Changes:

Apply to range: B2:B1000

=VLOOKUP(B2, INDIRECT("Type!A2:B"), 2, 0)="BM"
=VLOOKUP(B2, INDIRECT("Type!A2:B"), 2, 0)="JZ"
=VLOOKUP(B2, INDIRECT("Type!A2:B"), 2, 0)="PM"
=VLOOKUP(B2, INDIRECT("Type!A2:B"), 2, 0)="SD"