Data validation

  • Thread starter Thread starter flekso
  • Start date Start date
F

flekso

Problem:
3 date columns,
1st must be lesser than NOW(),
2nd & 3rd must be later than 1st.

Is there a way to create a rule that checks each cell of a column with an
adjacent one ?

I know how to validate whole column, but not two of them..
 
Hi
lets say you have col. A-C:
- For A1 enter the following formula in your data vali´dation dialog:
=A1<NOW()

- For B1 enter
=B1>A1

- For C1:
=C1>A1
 
Frank Kabel said:
Hi
lets say you have col. A-C:
- For A1 enter the following formula in your data vali´dation dialog:
=A1<NOW()

- For B1 enter
=B1>A1

- For C1:
=C1>A1
Click to expand...

But won't that just take care of the first cell in the column ?
 
Hi
just select all rows of your desired range and enter the formulas
(assumption your range starts in row 1 -> A1, B1, C1 otherwise change
these cell references accordingly)

Another way: Enter the formulas for the first row and copy (the blank
cells) down
 
That would be nice if it weren't for 1000+ rows in this sheet, i guess i'll
have to go route VBA...
 
Hi
no need for VBA :-)
- just select all desired cells
- goto Data validation
- enter the formula

The reference will change automatically for all rows
 
Frank Kabel said:
Hi
no need for VBA :-)
- just select all desired cells
- goto Data validation
- enter the formula

The reference will change automatically for all rows
Click to expand...

Ah, yes, i knew that all along, just checking if you knew :)

Thanks
 
Back
Top