Changing cells color without clicking command button

Hi. Thanks for this great forum and all its contributors. I have learnt a lot from this. I have a problem here and hope some kind souls will help. Thanks!

Problem :
I need the color of cells B1 to B10 to change according to changes I make to its contents/text value *without* clicking a command button.

A1 = Pricing
A2 = Contract
A3 = Implement

Cell range = B1:B10
If B1 = Pricing, color it blue.
If B1 = Contract, color it red
If B1 = Implement, color it yellow.
Repeat for B2 to B10.

Any help is greatly appreciated!!!

Hello grumpyguppy,


Conditional formatting will do this for you based on your formulas. Select the cells and under Format select Conditional Formatting... and follow the prompts.

Sincerely,
Leith Ross

Thanks Leith for the suggesting conditional formatting. My actual range of cells to format is huge, so formatting these one by one is not ideal. I need VBA codes. Thanks!!!

Thanks mikerickson. Conditional formating has only max 3 conditions. My number conditions is more. How do I use conditonal formating in this case? Thanks for helping!