Data Validation Formula Help

[Barbara Excel]

Guys
Looking for small bit of help on data validation formula

I want to force a user to enter a date in C2 if B2 contains any of the words Car, Boat or House

If B2 is blank, then no action needed

Appreciate any help as ever

Barbara

[judgeh59]

=IF(OR(UPPER(B1)="HOUSE",UPPER(B1)="CAR",UPPER(B1)="BOAT"),NOW(),"")

put this in column C and copy down...I set it up so if they enter it in lower case the match will work...HTH

[judgeh59]

Sorry....you'll also need to format column C in date format

[Fotis1991]

Will the user type also in another column something else?

[judgeh59]

I suppose technically mine will not force them to type those words....it will do the second part of your question....to do the data validation part you can set up a standard data validation list....

[Fotis1991]

@ Ernest. Point is that you can not force anyone to do something if you don't block him(her) for doing something else..

[judgeh59]

@Fotis - I totally agree....which is why I sort of retracted my thought....thanks for clarifing
@Barbara - If you want a date in Col C if one of the words shows up in col B then setup data validation in Col B for those word and use my formula and then nobody will "Have to" enter the date in Col C if the choose something from the data validation...unless you really want to force the user to enter the date...I guess another question is what date are they entering?....my formula enters today....I hope I'm not confusing the situation....