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?

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


--
Nigel_hough
------------------------------------------------------------------------
Nigel_hough's Profile: http://www.excelforum.com/member.php...o&userid=20623
View this thread: http://www.excelforum.com/showthread...hreadid=394263