Hi, I have a question about setting up a table where new rows added to bottom
of table are colored according to conditionally formatted color of first cell

Example: Conditional Formatting is set up so cells containing the string
"Green" are colored green ,Containing the string "Blue" are colored blue etc.

Table

Color Price

Green 33
Blue 27
Red 29
Orange 25

My Prices are entered automatically using VLOOKUP function.

Now I am able to use Conditional Formatting to format first cell according
to string it contains, but I am wondering how to format second cell to match
first cell without messing up VLOOKUP function.


Thanks for your help.