How to get Tick & Cross value in data validation

[hsharma26]

Hi,

I want to create data validation with Tick & Cross sign. Is there any options to use Tick & Cross sign in data validation.

Please suggest ASAP.

Thanks in advance.

 

[etaf]

you could use different fonts in the cell
and then choose the tick and cross - characters

for example
Marlett font
use an "a" to get a tick use a "r" to get a X without the quotes

then you can use
a
r
in a list and use that for your data validation

there are lots of other fonts that will provide a tick and a cross

OR
you could use conditional formatting and the ICON set to get a cross or tick that way
along with a data validation list
and use the icon set to NOT display the cell value - just the icon
may look better

 

[hsharma26]

Thanks for ur quick response but I want to see Tick & Cross sign in drop down List. Is there any way to get Tick & cross in drop down list.

you could use different fonts in the cell
and then choose the tick and cross - characters

for example
Marlett font
use an "a" to get a tick use a "r" to get a X without the quotes

then you can use
a
r
in a list and use that for your data validation

there are lots of other fonts that will provide a tick and a cross

OR
you could use conditional formatting and the ICON set to get a cross or tick that way
along with a data validation list
and use the icon set to NOT display the cell value - just the icon
may look better

 

[etaf]

in your list goto

>insert
>symbol
select
>ARIAL UNICODE MS
character code
2713
and
2715
Or you will see other ticks and cross

that should appear in the drop down list now

 

[hsharma26]

Thanks a lot.

in your list goto

>insert
>symbol
select
>ARIAL UNICODE MS
character code
2713
and
2715
Or you will see other ticks and cross

that should appear in the drop down list now

 

[etaf]

your welcome