Conditional color fill

G

Guest

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.
 
G

Guest

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.
 
G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
How to add up all cells with no fill color 9
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
Sorting by Color in Excel 2003 5
Conditional formatting, based on a different cell? 1
Conditional Formatting 1
show fill color of a shaded row 3
Cond. formatting, based on other cell values? 3

Top