ozibryan
01-09-2006, 04:52 AM
I am sure this is a simple thing to do once you know how, however - by now, I resemble one of those cartoon characters that digs a very deep hole going in circles.
The attached example (JJacob) -has an initial worksheet (Simple) that has data validations applied to column A. These values are 1, 2, 3. In this example, if A1 selects value 1 then I'd want to shade C1 thru H1 light brown, so on and so on.
The subsequent worksheet (PF6) shows a suggested example sourced from JJacob (via RoyUK) which demonstrates how to use the values of a select statement to perfom various actions.
What I want to do is to adapt the JJacob sheet which uses a 'fixed' range of 'E37' to work for all rows in a column when selected, as per the simple example.
Any suggestions are really really welcome.
:hi:
The attached example (JJacob) -has an initial worksheet (Simple) that has data validations applied to column A. These values are 1, 2, 3. In this example, if A1 selects value 1 then I'd want to shade C1 thru H1 light brown, so on and so on.
The subsequent worksheet (PF6) shows a suggested example sourced from JJacob (via RoyUK) which demonstrates how to use the values of a select statement to perfom various actions.
What I want to do is to adapt the JJacob sheet which uses a 'fixed' range of 'E37' to work for all rows in a column when selected, as per the simple example.
Any suggestions are really really welcome.
:hi: