Hello, I am trying to write a VBA code to highlight a row in blue if any cell in that row contains the word "Scoping" (please note that there would likely be other text in that cell as well, it wouldn't be that word on it's own) in a range of A2:O500
I understand this can be done with conditional formatting, but I am building this as a templated macro to share with others and use on different sheets, so it's really easiest for us to do this as VBA
Is this possible?
I understand this can be done with conditional formatting, but I am building this as a templated macro to share with others and use on different sheets, so it's really easiest for us to do this as VBA
Is this possible?