• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combination of rules for data validation formula

lastkoz

New Member
I need to write a formula comining two rules in data validation field.
1711627769694.png

I need to have formula in data validation - which allows to enter only Date - and that Date to be later than the one in column K.
Columns K and L will be field by other persons - and should make the fields locked only to that criteria.
I tried some options of AND, countifs, etc - but can`t get it.
 
Last edited:

lastkoz

Against paste...
If the yellow sticker in the upper corner of the monitor is not enough, then I would try to use VBA to take care those.
 
Thank you,
If can`t be done without VBA - that clears it for me also. I did`nt like that part that I`m not sure that there is a way.
Maybe it`s time to learn it after many years of headaches :D
 
Back
Top