Hi,

We need to see you macro but if it's a worksheet_Change looking at A6 then a
change in A6 as a result of calculation won't call the worksheet change event
code. You would need to look as W6 which will call the event if it's value is
manually changed.

Mike

"akemeny" wrote:

I have a formula in column A6 that relates to W6. When W6 is changed to
Reject, the formula generates the appeal level. At which point my macro is
supposed to kick in and highlight the row the correct color, but it's
doesn't. What is the code that I can use to make all actions in a macro
happen automatically?