conditional formatting

[stone]

HI, GUYS.

is it possible, for me to use conditional formatting, what i am trying to do is,

if you enter a number in cell A1, for example 4, then cells B1:B4 will be colored "green", and if you enter for example 10 in cell A1, then cells B1:B10, will be colored "green"

If you have any idea how to do this, then please let me know.

BK
Stulli

 

[Aladin Akyurek]

is it possible, for me to use conditional formatting, what i am trying to do is,

if you enter a number in cell A1, for example 4, then cells B1:B4 will be colored "green", and if you enter for example 10 in cell A1, then cells B1:B10, will be colored "green"


Activate column B by ckicking on B on the column indicator.

Acivate Format|Conditional Formatting.
Activate Formula Is for Condition 1.
Enter as formula:

=ROW($B1)<=$A$1

Activate Format.
Select green on the Patterns tab.
Activate OK, OK.

 

[stone]

Thanx alot Aladin.

BK
Stulli