B
Bob Myers
If a control number is entered in a Cell on a Worksheet, is there a way to
have that same number of Cells automatically highlighted (interior filled)
elsewhere on that sheet?
The number of cells highlighted should automatically change if the control
number is changed.
I don't believe there is a way to do it with conditional formatting, and a
macro would be after the fact.
Although I've written a number of macros and UDFs in separate Modules, I'm
not familiar with the coding of individual Worksheets in the VB Editor.
Respectfully submitted,
Bob Myers
have that same number of Cells automatically highlighted (interior filled)
elsewhere on that sheet?
The number of cells highlighted should automatically change if the control
number is changed.
I don't believe there is a way to do it with conditional formatting, and a
macro would be after the fact.
Although I've written a number of macros and UDFs in separate Modules, I'm
not familiar with the coding of individual Worksheets in the VB Editor.
Respectfully submitted,
Bob Myers