Hi, all!!!
I'm trying to get a macro to do a yellow highlight of two specific cells in a row, then search down to the next cell with data in it and highlight two cells in that row. I'd like it to do this all the way down until it doesn't find any more data in a cell when it searches down.
Looking at all of the examples on Microsoft's Excel website regarding this, it only give examples of exact cells to use for your highlight. I mean, you tell it what specific cells to start and stop on. That works fine for my first two cells to highlight, but the next two (and any beyond that) are in the same columns, but not at exact cell locations. There could be two rows between occurrences, 10 rows, 40 rows. Who knows? The first two highlights always start in the same cells, but this spreadsheet is NEVER the same from week-to-week other than that.
The macro I recorded highlights the first two cells just fine. But the search down for the next cell with data in it is not always at G11:H11 as the macro shows. So this will usually highlights blank cells.
I guess it's easier to show what I would like to happen. What I've attached would not be in the same spreadsheet. I've included the "clean sheet" at the top, and the results I'm trying to get below. So this spreadsheet would really only go down to row 25.
I'm trying to figure this VBA stuff out, but it's not all that easy. Every programming language always has its own terminology.
If anyone can help, I'd greatly appreciate it.
Thanks in advance.
Steve
Bookmarks