Hi All,

Just wondering if anyone knows if this is possible with out any VBA coding or not.

I have spreadsheet with some dependant data validation for text which works fine using lists, named ranges and the INDIRECT formula. I'm looking for a way to restrict the data validation in one column to a numerical range based on the value of an adjacent cell - "In" or "Out".

If the cell value is "In" then i'd like to restrict the numerical range from 0 to +1.0000 and if the value is "Out" then restricted from 0 to -1.0000.

I realise this is possible using a list but with the four decimal places (may need to be expanded to 6) then I don't really fancy listing all the possible numbers.

Any ideas?

Thanks, TC