this one is driving me nutso and it's so simple - I would just love to know why it doesn't work.
If a textfield (which is autopopulated) = GREATNESSs or GOODNESS, then I want the texbox to be editable, otherwise no. For that textbox, I select Conditional Formatting and I set the following logic: 'Rating does not contain great and Rating does not contain good' Then I apply the following format - I check the Read-Only. Simple. Doesn't work though, when the textfield (Rating) is populated with the text GREATNESS, it is still Read-Only. When I remove the conditional formatting, I am able to edit the textbox. This doesn't have anything to do with case sensitivity, does it? I would think not as when you select text when you use conditional formatting, it puts the text in lowercase. ANY suggestions would be appreciated.
Thanks for help