Hello,
i have a cell, A 1 which is a dropdown with the values from D1 to D5
i have a second cell, B 1 which is a dropdown with the values from D1 to D5, too
I want a formula for:
- to alert the user when he choose a value (number) from B1 that is smaller then what he choose on A1 (number)
If need i can upload the the excel document
thank you
Last edited by costahd; 06-12-2013 at 06:01 AM.
Suggest you to change your title to something that describe your problem.
If you don't want to use VBA, you have 2 options.
1) In C1 put this formula
=If(a1=b1;""ALERT";"")
2)In Conditional Formatting rules of B1 put this
=A1=B1 >>choose a color>>ok.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Fotis,
Costahd,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I think for that you have to use another dedicated call for warning.
Pls have a look at the attached sheet
warning.xlsx
Wrong entry.
I see no point of suggesting changing title and providing answer?
Originally Posted by Fotis1991
thank you all, and yes i might miss-understand the rules, will not happened next time
As you are not so often here last time, it's something that do many many others and NEVER no ADMIN, no MOD told them even 1 word for this.... Did't you ever noticed this?
So i just did the same that many others did(do) without anyone being bothered.
Rules must be the same for everyone. Not different just for me
I didn't gave you any kind of warning.
I do appriciate your effort for point people on right way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks