Fill cells based on value
 

I am looking for a way to fill a number of cells in a row/column based on a particular cell's value. So, if a cells value is say 7 or 3, then 7 cells or 3 cells must be be filled with a particular colour.

Thanks in advance

Fill cells based on value
 

I am looking for a way to fill a number of cells in a row/column based
on a particular cell's value. So, if a cells value is say 7 or 3, then 7
cells or 3 cells must be be filled with a particular colour.

In my example, cells of column A are filled in based on the value in cell C1.

Select column A and use "conditional Formatting" with "use a formula". The formula is
=ROW()<=$C$1
Choose the format and click OK.

With Excel 2010, when I update C1 the filled rows don't change (for some reason) until I select column A.

Hope this helps getting started.