Conditional color fill
 

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.

Conditional color fill
 

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.

Conditional color fill
 

This doesn't seem to work. When I select the range it doesn't seem to have
any effect to what happens. Can I specify the range in the formula? Again I
am using 2007.

"Wigi" wrote:

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.

Conditional color fill
 

I figured it out. You were correct if I actually used this formula in A1 but
because I started in A59 I needed to add 59 to the B1 Value

"Wigi" wrote:

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.

Conditional color fill
 

Variations on the same theme... ;)

Glad it's solved.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Eric" wrote:

I figured it out. You were correct if I actually used this formula in A1 but
because I started in A59 I needed to add 59 to the B1 Value

"Wigi" wrote:

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.