Highlighting a range of cells, only when a certain range of cells is selected

Hello,

I have one worksheet, that has 2 different sets of useful information within the columns i am trying to conditional format.

I am trying to create 2 different conditional formats, one for the first set of columns, and then another for the second set of columns.

I want to be able to select a cell, and then it highlight all the cells on that row that are in the first set of columns...( i figured out how to make it work by highlighting the entire row, but the problem with this in my situation is the rows dont match up when i get to the second half of important columns.

Does anyone know how i can only highlight certain columns rather than the whole row.

The code i am using right now is

Please Login or Register  to view this content.

im thinking i need to do something like this:

Please Login or Register  to view this content.

but i don't know how to include a set columns, not just the one (AG) or all by using (row)

hopefully someone can help me.

I'm not posting the sheet on here because i feel like if i know the correct syntax code to use i can apply it myself.


Thanks!

im not sure exactly what i did, but somehow i got it to work the way i want.. is there a way to delete post? or marked as solved?

It would be nice if, for other people with the same or similar problem that are searching for a solution, you showed the complete code.

Sure, that's a great idea!

Ok, so i had my first section of columns that when i selected a name, i wanted the worksheet to find that name within an array of all the names and a few pieces of information about each person, and highlight that row, but only 9 columns.

so i applied this formatting to the cells that i wanted to be highlighted..

Please Login or Register  to view this content.

and then further over, my next set of columns, i had all those names again but with a lot of information about each employee, so much, that i had to repeat the names multiple times so i could see what name i was looking at (52 columns to be exact).. anyways, i wanted just those 52 columns to highlight whatever row i was on.. i did this by applying the formatting to all 52 columns

Please Login or Register  to view this content.

and wallaa! It's not perfect, because when i select a name from the first set of columns it still highlights that row of the second set of columns, that doesn't necessarily associate with the correct person that i selected.. but because those rows are so far over, i don't even really see them on the screen.

So my way was more a work around, but it works for me.. I'm not sure how to make it not highlight the second set of columns if I'm selecting something from the first set.

If anyone does know how to do that, I would love to know, and it might help others too as jolivanes mentioned.
If not, it's okay, I am content with what i have now.