"Disable" a button after it is used
I know this has come up in the forums before but I can't seem to find a definitive answer that works. I'm sure it's Conditional Formatting with a formula that will, "Make the button text grey after you select it". I just can't get the right formula. I've included a screen shot of the button, showing the finished result. Because this database is for many people, I want to indicate this action has already been performed and is now greyed out. I apologize if this has already been answered, but I just couldn't find one with a well explained formula. Thanks.