Good afternoon, I am trying to create a formula that compares a value from a cell to a value in a range and then hi-light that cell and the 6 cells to the left of it in the same row and 2 cells to the right of it. I know this is a piece of cake in VBA, but I am trying to avoid vba and use the worksheet conditional format function but I can't figure it out.

I'm using the formula below to find the last used cell in a range in column G, take the value in H of that row and find that value in a specified range in column P.


The formula works and returns the row number. I would now like to take that and hi-light that cell as well as the 6 cells to the left and the 2 cells to the right using conditional formatting. I tried incorporating offset but could not figure it out.

thanks for any help in advance