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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks