Validation list display

[hstaubyn]

Hi,

I am trying to setup a number of cells with a validation list allowing "Yes" or "". I would like the cell value to equal 1 when "Yes" is selected. Is this possible without VBA?

The reason for this is because I want to set up conditional formatting with the tick, cross, exclamation mark icon set (With a tick appearing for "Yes"), but this conditional formatting only works with numerical values.

Thanks,
H

 

[DonkeyOte]

Create the list as follows:

In A1 type 1 - apply Custom Cell Format to A1 of: "Yes"
In A2 type 0 - apply Custom Cell Format to A2 of: "No"
repeat if nec. for other options

Create your Validation cell and tie to contents of A1:A2

You should find that when you select Yes the number 1 appears (0 for No).