Bob Myers wrote:
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


Select the entire sheet and then use the following for conditional formatting
(select the fill pattern desired):

=AND(ROW()<=$A$1,COLUMN()<=$A$1)

Put your "control number" in A1. Some variation of this could work for you.