I have created a code which colours from A2 to M2 based on the value in column M2. For example, if M2 = "Yes", the cells colour green, if M2 = "No", the cells colours red and for any other situation the cells remain blank. The code also runs automatically at the moment which I want it to do.
However, now I've got this working I want to apply it right from row 2 to row 1500. I'm very new to VBA and so this is probably very basic, but I'd appreciate any help!
Please Login or Register to view this content.
Bookmarks