Have a look at Format | Conditional Formatting
Then come back if more help needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Neil Pearce" wrote in message
...
Dear all,

How do I do the following please...

Cell A1 contains a number from 1 to 100.

Cells B1-B100 (depending on nr in cell A1) will be filled with blue.

i.e. if cell A1 contains the number 40, cells B1-B40 are all highlighted
blue.


Thanking-you in advance,

Neil