View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Format the cells as Windings 2 and then use values of O and P in the DV.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary T" wrote in message
...
Hi,

I want to be able to get a grid where, in each individual cell, the user

can
select only a tick or a cross - i.e. from the "Wingdings" font, characters
251 and 252.

How do I get Data Validation to allow me to do this? (i.e. so that the

drop
down list for each cell displays only a cross or a tick?)

Many Thanks,

Gary T