Highlight field when value is changed

  • Thread starter Thread starter eastrivergraphics
  • Start date Start date
E

eastrivergraphics

I have multiple rows of data, each one starting with a number. If the
number in the front of the row changes, I need that whole row to be
highlighted. Then I need a check box on the other side of the row so
that I can turn off (reset) the highlighting.

1 2 3 4
a # Name S Reset
b 21 Jane Hanson F
c 22 Mark Johnson M
d 23 Fred Lee M

I know I can do this with track changes, but we can't use that
because of other issues.

Can anyone tell me where I can get info on trying to make something
like this?
 
I think I'd use a Worksheet_Change event tied to column A to change the row
colors and a Worksheet_SelectionChange event on column D to change them back.


HTH (a little)
Barb Reinhardt
 
Back
Top