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
Bookmarks