Hi all!
Excel VBA novice back at it again. I am trying to create a macro that will search for a column by header name that is in the first row. And then search only that column for cells that value = 0. If they do = 0 I would like to highlight the entire row where that value exists as it needs to be marked in my data set.
For simplicity sake We can search for a column called Service. Then search that column for values of 0. And then highlight the row where the 0 exists. Any help would be greatly appreciated and I apologize if I left any important information out. I can't send the actual data set, but if necessary I will provide a dummy sheet to replicate my needs.
Thank you,
Scott
Bookmarks