Auto Shade Cells (Graph)

[keithb]

I need to make my own graph. I have 28 columns to turn into shaded columns
I want to place a number in a cell and it would would cause that many cells to be shaded in above it. Is that possible?
Lets say we placed 60 into cell A75. I would like cells A74: A14 to be shaded in green.
Can this be done for each of my 28 columns?

 

[dave3009]

You can use conditional formatting for this, highlight from A1 to A74 then go to Format>>Conditional Formatting

Formula Is:
=ROW(A$74)-ROW() < A$75

Set green fill format

You can then drag this across the 28 columns.

 

[keithb]

Thanks Dave3009, it does exactly what I need it to do.