Hi
assuming B1 holds the 10:
Select in column A a range that is large enough. Use Format Conditional
Formatting, then "Formula is":
=ROW()<=$B$1
apply your yellow colour. Hit OK.
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"Eric" wrote:
The user will enter a number, let's say 10. I would then like Excel 2007 to
fill (with yellow) 10 cells starting at A1. In this example A1-A10 would be
colored yellow.