Is it possible to have Cells Fill in a character if values are met?

[hammerhead13]

What I am trying to accomplish if is is possible is if the value on the left is within the Range then the Rating on Right will insert Stars 1/ Cell.

Is this Possible? Thank you!


[TABLE="width: 500"]
<tbody>[TR]
[TD]Values[/TD]
[TD][/TD]
[TD]Ratings
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]80-100[/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]60-79[/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50-59[/TD]
[TD][/TD]
[TD]*[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Is this what you mean

Book1
	A	B	C	D
2	80	*	*	*
3	50	*
4	60	*	*
5	99	*	*	*
6	49
7	78	*	*
Sheet2

Cell Formulas
Range	Formula
B2	=IF(A2>=50,"*","")
C2	=IF(A2>=60,"*","")
D2	=IF(A2>=80,"*","")

 

[hammerhead13]

Thank you. I can make it work with that.

 

[Fluff]

You're welcome & thanks for the feedback