Conditional formatting certain cells when another cell is highlighted

**thadacto** · 08-21-2009, 11:23 AM

I want to change (via conditional formatting) the background colour of cell H64 and K72 when I select / highlighted / activate (i.e. just left click in the cell) cell C66.
I don't seem to be able to find in the formulae something to indicate if C66 is selected / highlighted /activated.

Any pointers in the correct direction would be gratefully received.

**ChemistB** · 08-21-2009, 11:27 AM

It cannot be done with Conditional Formatting. It would require VBA coding.

**thadacto** · 08-21-2009, 11:38 AM

And that would be way over my head, I think - I've never heard of VBA Code before!! I assume it is somewhat complicated.
Many thnaks for the info.

**ChemistB** · 08-21-2009, 11:53 AM

It's not that difficult. (well some of it is

)
With your sheet, right click on sheet tab and choose "View Code" This opens up the VBA Editor
Paste this code into the code window

Please Login or Register  to view this content.

Close the VBA Editor (no need to save, it's linked to your workbook).
See if the code works. It should change H64 and K72 red

**thadacto** · 08-21-2009, 12:00 PM

Many thanks ChemistB, that works.

I'll now work on modifying the code for the cells I want to change.

Thanks again.

**ChemistB** · 08-21-2009, 12:01 PM

I corrected my code above to return to no color if another cell is selected.

**thadacto** · 08-21-2009, 12:11 PM

I put the code in before you changed it and It worked fine.
The edited version is perfect - thanks.
I have some idea of coding as I write some small games using a special program and therefore do have some idea of coding.
I'll have to investigate VBA more when I get the time.
Thanks again.