Hi all,
I'm interested in using "model" cells for formatting. To explain, A1 to A(undetermined) contains key words in each cell, each cell is using a different fill.
I'll then use "For Each Cell In" my given range. I'm not sure what comes next, but I need a way of saying If Cell.Value =/contains (think I can do contains with LIKE) a value from the key starting in A1, use the formatting (NOT the text) of the matching cell.
I'm trying to make the sheet "user friendly" - so changing fill colours etc is as simple as changing the model cell and no user has to go digging around in VBA for Cell.Interior.
Thanks for any suggestions
I'm interested in using "model" cells for formatting. To explain, A1 to A(undetermined) contains key words in each cell, each cell is using a different fill.
I'll then use "For Each Cell In" my given range. I'm not sure what comes next, but I need a way of saying If Cell.Value =/contains (think I can do contains with LIKE) a value from the key starting in A1, use the formatting (NOT the text) of the matching cell.
I'm trying to make the sheet "user friendly" - so changing fill colours etc is as simple as changing the model cell and no user has to go digging around in VBA for Cell.Interior.
Thanks for any suggestions