I placed a question on General Questions with no resolve and Im hoping to
find it on this board.

Problem: I need to affect a color change in cells that are in a range of 12
cells
based on an auto-populated value.

Criteria:
Cell range o5:o28
(Why the range is larger than 12 is that the cells are merged to equate to
only 12 cells, o5-o6, o7-o8, o9-o10 etc.)

In the workbook there are 12 identically formatted sheets that have this
range on them. Each sheet has a different name. R1, R2, R3, etc.

In the workbook there is also 1 data source sheet that the 12 sheets feed
from to get the cell value from. The value is dumped to the 12 sheets then
using a Vlookup formula in each cell of the range, the cells get their value.


The value that is auto-populated is always 1 thru 12 ( o5 could be 11 and o7
could be 7 and so on. ) Sometimes they are blank.

EXCEPTION: The user cannot manually enter the value or can they press enter
to effect and Event.

Thanks in advance.
EXCEPTION: The user cannot hit enter to cause the change. The event coding
using Case did not work well.