still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
Hi
I’m using this formula in Conditional Format to highlight if the word “book” is in D:D
If the word is plural (ends in s), or has a number before it, it won’t highlight it.
As an example …the entry maybe ...... 2 books .... or just ...books
The number may be different
I’ve tried
=”*book*”
&
=”?book?”
I thought about having more conditions but the number may not be the same
mike
I’m using this formula in Conditional Format to highlight if the word “book” is in D:D
If the word is plural (ends in s), or has a number before it, it won’t highlight it.
Excel Formula:
=$E$4=”book”
The number may be different
I’ve tried
=”*book*”
&
=”?book?”
I thought about having more conditions but the number may not be the same
mike