Using Case Loop to Find a String and Color Cell

Hi All,

I’m trying to assign various cell colors based on a string in column “E”.

I’ve cobbled together the following code but it just isn’t working.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

Try this

Please Login or Register  to view this content.

This works perfectly. Thanks, Bob I really appreciate it.