Sorry I know it will be simple
want a1 to have text of either "andrew" or "trudy" what is the formula for this? I don't want a drop down menu just a formula and alert if it is not either of these
regards
andrewm
Sorry I know it will be simple
want a1 to have text of either "andrew" or "trudy" what is the formula for this? I don't want a drop down menu just a formula and alert if it is not either of these
regards
andrewm
You can use data validation that permits only one of there names, not a drop down list, but ... you question has no logic, maybe you should explain a why so it makes more sense.
If it's the acutal username, that just fille that cell with the active username when the file opens.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
U
se conditional formatting for Cell A1 as an alert
=AND($A$1<>"andrew",$A$1<>"trudy")
Format as Red
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks