Hello Everyone,
I have data in which I want to highlight the cell on the basis of text.
For example:- I have a list of data in a range in that I want to highlight those cells which has contains "Tain".
Thanks in advance
Ankit
Hello Everyone,
I have data in which I want to highlight the cell on the basis of text.
For example:- I have a list of data in a range in that I want to highlight those cells which has contains "Tain".
Thanks in advance
Ankit
Hi Ankit,
Do you know about how to set a conditional format?
Assume your text variable is in A1 - "Tain".
Assume you want to look at data in column B, then use the following as your conditional format formula =IFERROR(FIND($A$1,B1),0)
I hope this helps, please let me know!
Regards,
David
Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.
Last edited by David A Coop; 06-11-2015 at 02:12 AM.
@ David, Conditional Formatting works on only TRUE or FALSE, so I think you can do away with the IFERROR part and just use...
=FIND($A$1,B1,0)
or even...
=match($A1,B:B,0)
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
@Ford - good point! I guess I was testing in a cell before trying in the CF. Didn't think to take the iferror out.
Regards, David
I often do that too, much easier thay testing in the CF window. When I do that, I structure the test formula to return TRUE or FALSEI guess I was testing in a cell before trying in the CF.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks