VBA Highlight Row On Cell Value Change

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm trying to put together a very simple script which performs the following:

• Look in column B of my sheet.

• If the value of "Submitted" is found shade the row from columns B:O.

• If the value of "Unsubmitted" is found, do not shade the row.

In addition, I would like to highlight or remove the row highlight when the cell value changes, rather than by a 'Button Click'

The code which I've put together so far is shown below, but I'm receiving a compile error when I run it.

Please Login or Register  to view this content.

I just wondered whether someone may be able to look at this please and let me know where I'm going wrong.

Many thanks and kind regards

[:) Sixthsense :)]

May be try this…

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[hobbiton73]

Hi @AB33, thank you for taking the time to reply to my post and for the solution.

I'm trying to activate this macro upon a cell change being madein column B, so I've tried to adapt the code you kindly provide to:

Please Login or Register  to view this content.

But unfortunately I'm receiving an error when I run this.

Could you possibly tell me please where I've gone wrong?

Many thanks and kind regards

[AB33]

Please Login or Register  to view this content.

Or you could use on the second line

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[hobbiton73]

Hi @John H Davis, thank you very much for taking the time to reply to my post and for putting the solution toegether, it is greatly appreciated.

Kind Regards

[hobbiton73]

Hi @SixthSense thank you for taking the time to reply to my post and for putting the solution toegther, it is greatly appreciated.

Kind Regards