Help please. I am trying to highlight all cells in a large spreadsheet that contain the same certain text value. For example all cells contain text such as "B6 - A5", or "C7 - B4" etc. (These are not cell references, they are softball team designations) I am trying to highlight all cells that contain for example the text "B6". Nothing I've tried seems to work.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting
- Thread starter twmoore
- Start date
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
amazingd said:
How this differ from what is already on offer?
Upvote
0
Excel Facts
Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Barry Katcher
Well-known Member
- Joined
- Feb 25, 2002
- Messages
- 4,053
Aladin, just got home and sat down and thought I'd try something before tackling the VBA. I altered your conditional formatting formula to:
=SEARCH(TEXT($C$2,100),A1)
where the user inputs the text to find and then highlight in cell C2. Woiks.
Only downside is that I didn't learn anything new about VBA, although I will have to tackle it if I want a macro to scroll through the range to find and highlight each occurrence in order. Maybe manana.
Amazingd, thanks for your formulas. I tried your FIND +1 and +4, it works fine as long as the first argument is in the form of the "text" you're looking for, but doesn't work if it's a cell reference. I got it to work with the TEXT argument, same as I used above for Aladin's SEARCH formula:
=FIND(TEXT($C$2,100),A1)=1
...and
=FIND(TEXT($C$2,100),A1)=4
I believe Aladin's is more versitile, though, since it is not limited to the position of the text within text.
Again, thanks Aladin and amazingd.[/i]
=SEARCH(TEXT($C$2,100),A1)
where the user inputs the text to find and then highlight in cell C2. Woiks.
Only downside is that I didn't learn anything new about VBA, although I will have to tackle it if I want a macro to scroll through the range to find and highlight each occurrence in order. Maybe manana.
Amazingd, thanks for your formulas. I tried your FIND +1 and +4, it works fine as long as the first argument is in the form of the "text" you're looking for, but doesn't work if it's a cell reference. I got it to work with the TEXT argument, same as I used above for Aladin's SEARCH formula:
=FIND(TEXT($C$2,100),A1)=1
...and
=FIND(TEXT($C$2,100),A1)=4
I believe Aladin's is more versitile, though, since it is not limited to the position of the text within text.
Again, thanks Aladin and amazingd.[/i]
Upvote
0
Similar threads
- Solved
