Changing individual cells based on entries in adjacent cells
Posted by Jerry on February 05, 2001 6:23 PM
I'm trying to understand how to automatically trigger an Event or Macro for cells in a spreadsheet'
I have 5 Rows in a sample spreadsheet
I would like the background of the cell in the adjacent column to automatically change to the color based on the users entry.
If the user enters R, G, or B in cell A1 how would I cause the background in cell B1 to change to Red, Green or Blue?
The user then goes to cell A2 and enters R, G, or B in that cell. The background of the adjacent cell B2 should change to the selected color. The color entered in A2 will likely be different than in A1.
Same for A3, A4, and A5
I am aware of WatchIT and Worksheet_Change but those seem to allow change based on a WatchArea, not individual cells.
Please respond via email