Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
Hi,
I have row ( e16:AJ16) and I need some VB so if a cell , or cells contain a certain word , it/they will change colour to blue?
elow is what I have to use & the red grided area is where I would like to apply the code.
please can someone with the knowledge please provide?
Thank you kind coders.
I have row ( e16:AJ16) and I need some VB so if a cell , or cells contain a certain word , it/they will change colour to blue?
elow is what I have to use & the red grided area is where I would like to apply the code.
please can someone with the knowledge please provide?
Thank you kind coders.