G0dsreaper
New Member
- Joined
- Jan 14, 2021
- Messages
- 6
- Office Version
- 2016
- 2013
- Platform
- Windows
I want a worksheet change event to only take affect when anywhere in Column H the word "Cancelled" is found. I would like it change the fill of the range (A:H) of the target row red and change the font to white with a strike through. I have had this sort of work with my current sheet but I get an error every time I run my macro that adds another set of data from another sheet. If Hit end of this error, nothing happens and the code works as intended when I select the word "Cancelled" from the drop down menu.
The other issue I am having is that if I accidently choose "cancelled" instead of one of the other words in the drop down menu, I cant change the formatting back without doing it manually. Is there a way around this? Can someone help me out?
The other issue I am having is that if I accidently choose "cancelled" instead of one of the other words in the drop down menu, I cant change the formatting back without doing it manually. Is there a way around this? Can someone help me out?