Hi,

Even after looking over the 11/5 message I am not sure what you are trying
to do, but I am guessing you have a large range of cells containing 3 digit
numbers in each cell. And you want to enter a 1 to 3 digit number in a cell,
say A1 and have the all cells in the range format with a given color.

Suppose the 3 digit numbers are located in B1:J100, highlight them and
choose the command
Format, Conditional Formatting, and from the second drop down pick equal to
and in the 3rd box enter =$A$1 Click the Format button and choose a color on
the Patterns tab, then click OK twice.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"ghinzrey" wrote:

Wish Mr. Johnc could provide step by step as an example of what to do. Sorry,
but I'm just a beginner on excel. Thanks