Search for a column based on a header name and then searching only that column

Please Login or Register  to view this content.

Great thank you! Works like a charm!

As a follow up, if I wanted to do the same thing, but instead of searching for 0... I wanted to find cells where the first two characters were "zz" and then highlight. How would I go about doing that?

Change the first Set d line to:

Please Login or Register  to view this content.

FWIW:

Please Login or Register  to view this content.

You guys are awesome, thanks.

Gonna throw this in here too since you guys have been so helpful. I have tried to get this one answered before to no success, but it runs along these lines.

Its based off of 3 separate columns. FY, Location, and O&M.

FY has 4 possible values : 2010-2013
Location has hundreds of locations. Each location has data for all 4 years so each location appears 4 times in the data set.
O&M is cost data

I want to find the column O&M and search for where it = 0 for the latest 2 years (FY = 2012 and FY= 2013). When that is true I want to highlight all 4 rows for that location that has reported 0 for the last 2 years as it signals to us that they are no longer collecting the data.

This is fairly straightforward, and I've no issue providing a solution, but this really needs to be a new thread to comply with forum rules. If you post it as a new thread, I'll see it and answer.

Ah ok, sorry I am new here. Just posted. Thank you again for all of your help.