I have a company travel spreadsheet seperated by month (each month on seperate tab currenlty hidden in file) that I want to use Data Validation in order to have a pop-up message box appear warning travelers they entered travel dates indicating travel of more than 7 days. Attached is a copy of the spreadsheet with the data validation already there, in Column H.
Currently, the pop up message happens no matter how many days, be that 10 tens or 2 days, the warning box still pops up even if it's not true. The formula for the data validation is based upon the value in cell I, which is a formula.
How can I get the pop up message to correctly only pop up when cell I2 (I3, I4, etc) is greater than 7?
I have tired all different kinds of options but nothing seems to work.
Once I can get this fixed I will need to apply this to all the "monthly" tabs in the spreadsheet.
Bookmarks