Star if>10

[copeco]

I have a list of names. The cell next to the name adds the number of times the name shows up in the worksheet. I'm wishing, in another area of the worksheet, to show a "*" (star) for every time over 10. e.g. 11=* 12=** I'm using EXCEL...thanks

 

[Zathras]

See my post in thread707-456276

 

[pmidwest]

=IF(A2>10,"*&quot

just put this in the cell you want to display the "*" changing A2 to the cell that has the numbers in it
hope this helps

Paul

 

[copeco]

thanks..much