color row based on table

[Don S]

Trying to color rows in spreadsheet based on table and variable

Table sheet is as folllows:

var1 color
var2 color
va 3 color

My code needs to be
If cell x in sheet Y = varx
apply color to entirerow of sheet Y

Any help?

[Nigel_hough]

Have You Tried Conditional Formatting

Its in Format > Conditional Formatting...

You can set the background colour of a cell/row based on a cells value.

You could do a condition for every colour you wouldn't need the colour table.

Hope That Helps