[solved] Cant get it to work, should be simple???

[wiskydiver25]

I have 4 cells cells that need to be compared. 2 of the cells need to be larger then the other 2 or it needs to kick out an error message. This is what I came up with but it just continues throwing an error message even if the cells meet the criteria listed..Here is what I have

Please Login or Register  to view this content.

[Sean Thomas]

try this

Please Login or Register  to view this content.

[wiskydiver25]

doesnt seem to work at all....

[wiskydiver25]

Im sorry it does work.. that you very much....however, it only works if I click the cell...these cells will be auto filled formula and locked from users. Is there a way for it to work like a macro, with maybe a button that is used to run it?

[wiskydiver25]

If I can turn this into a macro, i know how to do the button

[wiskydiver25]

also, how would I add a message for the conditions being met?

[JOHN H. DAVIS]

If I can turn this into a macro, i know how to do the button

Maybe:

Please Login or Register  to view this content.

[wiskydiver25]

I tried this alteration from what I posted previously as well, same result...continues to give the error message even when it shouldnt.....the code Sean provided works well, but I am wondering how to convert the code into a macro, or if that is even possible?

Any thoughts

[wiskydiver25]

Thank you john, yes it does work as a macro! Woot Woot. All problems solved

[FDibbins]

wiskydiver, i am glad you got a solution to your question

2 points i want to make though...

1. for future reference, please name your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it of interest to them, or falls within their area of expertise, and will only open those threads. also, searching for "help" will not turn up too many results that will benefit you, sorry

2. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)

[JOHN H. DAVIS]

Thank you john, yes it does work as a macro! Woot Woot. All problems solved

You're welcome. Glad to help out, and thanks for the feedback.