Good afternoon. I am trying to figure out how to find the first and last non empty cells and then color all cells in that row between/including those two cells. If there is only one value in the row I would want to just highlight that one cell. I would like to do this for all rows until the first blank row. I would like to do this for every row starting from D6:AG6 until the last non empty row. Any help/suggestions would be greatly appreciated.
Bookmarks