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