tick or cross con.format from list? Is it do/able?

[John Caines]

Hello All.
I have been on this for hrs, completely done my head in,, any advise greatly apreciated.
I have a sheet with column H & I I want to be able to show a tick or a cross in, if the assigned list shows either a YES or a NO.
I just cant get it to work.
(I did originally try windings, I just couldn't get it to work,, the dropdown list continued to show funny characters), so no joy with this method,, and don't want a VBA solution if I can help it.


Please view image,,, it's really stumped me.
IMAGE:
https://imgur.com/a/kNCnl5H
I attach a simple sheet also,
Sheet:
https://www.dropbox.com/s/5sa8ob3ljcz0s27/MrExcel_cross_tick_example.xlsx?dl=0

All I want to do, is if the word YES is selected in cell H2, it will display a nice green tick, via icon set if possible under conditional formatting.
Please, someone show me the light!
I'm going crazy here.


Many thanks in advance
a very frustrated
JC

 

[TonyUK72]

Copy this formula into cell I1

Format I1 to use the font type "Marlett"

Typing Yes/No into H1 will now give you your Tick or Cross.

 

[TonyUK72]

=IF(H1="Yes","a",IF(H1="No","r",""))

Might help if I give you the formula.......

 

[Fluff]

Change the font on your Dropdown sheet to Segoe UI Symbol
In select A1 (delete contents) then on the insert tab > Symbol > select the Segoe UI Symbol font > Subset Dingbats > double click the symbol you want.
repeat for A2

 

[John Caines]

Hi TonyUK72!

Thanks for your reply.

Nope,, I just get a funnny looking symbol!
And I dont want to type anything into coloumn H2:H202, or I2:I202,,,, I want to use the named dropdown list on the other tab withing the worksheet.
(Tab is called drop_down)

Is there anyway to do this, with drop down data TonyUK72?

here's image of the drop down data sheet

https://imgur.com/a/PbOmhIf

Any ideas how to do this Tony?
Cheers for your help
JC

 

[John Caines]

Hi Fluff,
many thanks for your reply.
But I don't understand it?

I'll create a very short video explaining my situation soi there's no confusion.
5 mins, I'll be back!

Many thanks
JC

 

[Fluff]

Paste these into A1 & A2 on your drop-down sheet
✔
✖

 

[John Caines]

Here's a quick video
https://www.dropbox.com/s/mrtq7o3z87zwodk/tick_cross.mp4?dl=0

Sorry Fluff,,
but It doesnt work for me what you suggested.


In the dropdown I still get funny looking symbols


Any ideas whats wrong here?
Many thanks
JC

Sheet is here
https://www.dropbox.com/s/2lhcg2u3sljkxdg/MrExcel_cross_tick_example-error.xlsx?dl=0

images
https://imgur.com/a/gGbX8Nm
https://imgur.com/a/xTZgIlZ

 

[Fluff]

Copy and paste the symbols from post#7 into your Yes_no range & change the font to Calibri.
Then try it

 

[TonyUK72]

Do you have the Marlett font available to you?

Do you get a TICK, if you enter "a" without speechmarks, and the cell has a font type of Marlett?

Can your workbook be macro enabled? E.g can you use VBA or would that cause other problems?

If the answer is YES to all three questions then we could create a YES/NO dropdown and have the cell automatically change to a TICK or CROSS upon selection of YES/NO from a dropdown.