It would be much simpler to use Conditional Format on the adjacent cells.

Mike F
"Piers 2k" wrote in message
...
Hi folks,

Tried searching the web for this, but don't know what event I'm searching
for!

I have a number of cells in a certain column (F9, F15, F16, F23....)
Non-contiguous. After the number is entered in these cells, I want it to
trigger a macro to effect the adjacent cell (bg colour and font colour)

I can construct the macro and assign it to a button, but I am unsure of
how
to tie it to a specific cell or cells.

Anyone?

TIA,
Piers