Way to highlight a specific number of cells based on number entered in another cell

[Affo01]

Hi,

Is there any way that if for you enter a number in cell A1 for example that the corresponding number of cells will highlight in column B?

eg - Cell A1 - 4 is entered. Any way then that this then highlights cells B1-4 in any way (by colour, border, number, letter or anything)?
Cell A1 - 2 is entered so B1 and B2 are highlighted in some way.

Been racking my brain and searching but not found anything. Last hope before I decide it can't be done is the fine folk on here.

Thank you.

 

[kevin9999]

Conditional format is the way I would go....

Book1
	A	B
1	4
2
3
4
5
6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B20	Expression	=ROW()<=$A$1	text	YES

Book1
	A	B
1	2
2
3
4
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B20	Expression	=ROW()<=$A$1	text	YES