Hi,
I googled and found applying conditional format using a formula is the way to do it.
What I found is to use something likeMy problem is that I've several tables (21 tables), and I am searching for the same "TEXT" in each table.
Please Login or Register to view this content.
But the word "TEXT" is part of the cell contents and not the entire exact contents.
The other problem is the size of the tables may change at any time according to random needs.
so how to fix this problem?
Book1.xlsx
Last edited by MGadAllah; 04-17-2023 at 07:15 PM.
maybe try...
=$C2="*text*"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Pls try
Condition format formula
Formula:
Please Login or Register to view this content.
Thanks for your valuable time helping me.
Did not work!Originally Posted by FDibbins
Did work!
Much appreciated for you all.
@MGadAllah You're Welcome. Glad to help . Thank You for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks