Harvey ball is literally the person who made the smiley face
@excelisfun
10 жыл бұрын
Thanks, Doug!
@CajunConstitution57
10 ай бұрын
Great job! Just what I needed.
@DougHExcel
10 ай бұрын
Hi Doug Perkins, thanks for the comment!
@kimdang4
7 жыл бұрын
Very helpful video. Moderator does a great job explaining his steps.
@DougHExcel
7 жыл бұрын
thanks for the comment!
@mackers43
8 жыл бұрын
Nice one, thank you for this, exactly what I was after!
@k____5697
5 жыл бұрын
Thanks! This was just what I needed at work
@DougHExcel
5 жыл бұрын
You're welcome!
@TheEmilyBoettcher
5 жыл бұрын
Thanks! Exactly what I needed
@DougHExcel
5 жыл бұрын
Hi TheEmily Boettcher, glad you liked it, thanks for commenting!
@eversenna
2 жыл бұрын
nice, thank you
@DougHExcel
2 жыл бұрын
Welcome 😊
@marasvenne691
11 ай бұрын
My excel doesn't have the arial unicode option. Other ideas to address the 'zero' conditional formatting technique?
@gauravchaudhry7133
2 жыл бұрын
Perfect 👍👍👍👍🥰
@DougHExcel
2 жыл бұрын
Thanks!
@kelegeisler518
2 жыл бұрын
very helpful video. Is it possible to create havey balls that represent 10% and 90%??
@DougHExcel
2 жыл бұрын
You'd have to create your own images. Then try using a lookup to bring them in. See kzitem.info/news/bejne/pZ2XsoZ8h6GIim0
@stevesullivan457
10 жыл бұрын
I found it to be very interesting but too blurry. It seemed to go in and out of focus.
@pena3132
3 жыл бұрын
Is there a way to insert a + grid inside the harvey ball?
@DougHExcel
3 жыл бұрын
AFAIK getting a + grid is not there for the conditional formatting or the Unicode format. The other option I can think of is to create a pie chart(s) with the different Harvey ball quarter with the + grid and then do the a lookups to get the image in. Image lookup vid here kzitem.info/news/bejne/pZ2XsoZ8h6GIim0
@elenadelgadoEHS1
5 жыл бұрын
Hi, are you still answering? it marks an error on my excel spreadsheet. why? I put in the conditionals if and get an error. checked it withy our step by step.
@DougHExcel
4 жыл бұрын
Sorry, don’t understand the comment/ question...
@weydesign
5 жыл бұрын
The problem with conditional formatting is that the harveyballs are pixelated. If you copy the table to powerpoint for example to do a nice presentation, it looks very crappy!
Пікірлер: 27