Hi there,
I know how to format cells based on specific text with the conditional formatting tool. What I now want to do is to clear the text from any cells that have not been highlighted using the tool.
I've tried to find and replace using the format of a cell but it doesn't recognize a fill when you do it via conditional formatting. Any ideas please?
Do you need to HIDE or DELETE the contents? If the former, you can probably do it with another CF rule. If the latter you will need VBA.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I need to delete the contents please.
What are the contents? It might be doable with Find & Replace. Can you share some examples?
The contents are just words. Example below, I have conditionally formatted every cell that contains the word "and"......now I want to delete the contents of every cell that is not highlighted.
example01.JPG
While this will not delete the cells that do not contain the word 'and', it should produce a range of cells that only contains the word 'and'.
1) Paste the following formula into cell B29: =IF(ISNUMBER(SEARCH("and",B23)),B23,"")
2) Drag the fill handle down to cell B33,
3) While cells B29:B33 are still selected drag the fill handle of cell B33 over to cell G33.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks