smiley face in to a cell if = A

[Nuno Silva]

Hy guys

have aquestion to discuss, and i dont know



i need a excel Sheet that would be like :

A	B	C
	116	117
OEE
5S
Basic Rules
QControll
etc
etc
...

<tbody>
</tbody>

And in B2,C2,B3,C3,..., we have a Data validation, or anything else, with smileys
Green Smiley
Green White Smiley
Yellow Smiley
Red Smiley

Or if we input the number 1 in B2 automatically insert a red smiley
if we input the number 4 in B2 automatically insert a green smiley
etc...

Its hard ? Its impossible to do ?

Thank you guys

 

[tmmellor1981]

i just tried you can copy the smiley face from word (use to create) then you would just need to apply conditional formatting to change to colour of the face

 

[Nuno Silva]

Thank you.

But already changed it because was giving me to much trouble ahah