On Click Highlights cells

Hi

I have cells that I would like to highlight every time I click a cell.

I have managed to highlight the range of columns and cells when I click on a cell but the problem is I have different groups that would like to do that. What's happening is when I click on a cell it highlights the cells also on the other group.

A range would be columns and rows. Grouped in different areas of the same sheet and will have a gap in between.

I have attached the sample to give a clear idea. Conditional formatting is used.

Thank you very much.

Hi

Thank you very much for your response. It's working perfect. But when I try the the formula there is a delay in highlighting the rows and columns. I need to refresh the worksheet to see the result.

Anything I'm missing here?

Regards and Thanks.

Hi

Yes I did. I copy the formula and adjust it to the one I'm working on. But it need to be refreshed before I can see the result. But on the actual sheet where you put the formula works just fine.

Thanks.

The another solution.
Because of intersect and array it must be used in names. Many "if" was add for calculation optimization. Also I use one CF for performance.
_Con1=

=IF(ROW()=CELL("row");IF((CELL("col")>1)*(CELL("col")<14);ISNUMBER(Data!$N13 Data!$N:$N)))

_Con2=

=IF(CELL("col")=COLUMN();IF(ISNUMBER(Data!$N8 Data!$N:$N);IF(ISNUMBER(INDEX(Data!$N:$N;CELL("row")) Data!$N:$N);LOOKUP(ROW();IF(Data!$N$7:$N$339="Total";ROW(Data!$N$7:$N$339)))=LOOKUP(CELL("row");IF(Data!$N$7:$N$339="Total";ROW(Data!$N$7:$N$339))))))

CF

=IF(_Con1;1;_Con2)