Setting default validation depending on another cell criteria

[Zyphon]

Hi Guys,

I have a list validation for a column of cells with the options of "Yes","No" & "Pending".

Is it possible to set the default validation to "Pending" if say cell A2 was not blank?

Thanks.

[Mark@Work]

I think I've got something at least close to what you want.
in the Validation Allow: drop down box choose "List"

then in source: type in
=IF(ISBLANK($A$2),$A$3,$A$3:$C$3)

Set A3 to "Pending", B3 to "Yes", C3 to "No"
(obviously choose 3 convenient adjacent cells to suit your spreadsheet and change the formula appropriately).

Mark.

[Zyphon]

Hi Mark,

Thanks for your help this kinda works but I wanted to know if it populate itself but I am guessing that is impossible?