Forum Discussion
Conditional Formatting - Highlighting sheet names linked to a value in a cell
Huh???
You want to click on a cell and have what happen? Please explain better...
Are you familiar with Visual Basic for Applications (VBA) the automation programming language in Microsoft Excel? If yes are you familiar with the worksheet events that you can trap and run code?
OK I am getting too old... I need new glasses, or maybe a whole new brain... I'm not sure.
Georgie.
Hello, unfortunately I am not familiar with VBA, I have just recently started using Excel for tracking deficiencies in new home construction and my experience with coding is minimal. I'll try to explain better what it is I am trying to do.
I have 60 identical sheets with Suite Selections in them, this includes all upgrades and notes for finishing a suite. On the 61st sheet I am tracking totals of things for ordering purposes so the set up is roughly like this...
Column "A" is a list of appliance model numbers.
Column "B" is totals for each model pulled from the 60 sheets using
=SUMPRODUCT(COUNTIF(INDIRECT("'"&I2:I61&"'!C7"), E12))
Column "C" is the list of the 60 sheet names (suites) from which the above formula pulls totals.
(101, 102, 103 etc.)
When I click on a cell in Column "B" I would like the associated cells in Column "C" to highlight indicating where those appliance models are to be installed.
