VBAProIWish
Well-known Member
- Joined
- Jul 6, 2009
- Messages
- 1,027
- Office Version
- 365
- Platform
- Windows
Hello All,
My first question in awhile here.
So, my question is this...
If the cell in the column named "office" is not blank, and the cell in the column named "Location" does not say "America", highlight the cell in the "Location" column red.
A couple of things to note....
1. I would like the search to stop at the bottommost row with data in column header named "report" as this is always the longest column with contiguous data.
2. The columns may switch around, so I would like the searches to find the cells based on their column header name, not column position.
3. I would like all search criteria to be case iNsEnsiTIve.
Thanks much!
My first question in awhile here.
So, my question is this...
If the cell in the column named "office" is not blank, and the cell in the column named "Location" does not say "America", highlight the cell in the "Location" column red.
A couple of things to note....
1. I would like the search to stop at the bottommost row with data in column header named "report" as this is always the longest column with contiguous data.
2. The columns may switch around, so I would like the searches to find the cells based on their column header name, not column position.
3. I would like all search criteria to be case iNsEnsiTIve.
Thanks much!