jbarrick007
New Member
- Joined
- Jul 9, 2020
- Messages
- 36
- Office Version
- 365
- Platform
- Windows
I have a chart that displays various tasks but then also who is it assigned to. I then have a drop down box with a list of all those roles, and a conditional format rule create dot highlight all the cells based of matching text. This is working with a few exceptions. I'd be grateful for recommendations on improvements.
For example, C11 says
C14 says:
and C17 says:
My problem is if I make my condition format, based of matching text of FR, it will highlight all three cells. I wouldn't want C14 highlighted because you do not find FR withing the parentheses, which is the spot for the assigned roles. It will highlight because it is finding FR within the abbreviation CFR.
If I change it to look for (FR) then I only get C17 highlighted, but I would still want C11 highlighted.
The only way I can figure to do this is create several more helpers cells to text join so that C11 and all other cells would look like
This is an easy fix, but that it changes the one one tab looks/reads compared to all the other tabs and documents.
Is there anyway to get it to search only after the hyphen or within the parentheses?
One of you genius' out there may have a solution. I'm hoping conditional formatting will still work and not resort to adding VBA. Thanks so much.
For example, C11 says
• Produce Approved for Permit (AFP) Drawings - (TR, FR, DD) |
• Send investigation meeting assignments to CFR through MS Teams - (FCR, DD) |
• Send out the SOW meeting invitation - (FR) |
My problem is if I make my condition format, based of matching text of FR, it will highlight all three cells. I wouldn't want C14 highlighted because you do not find FR withing the parentheses, which is the spot for the assigned roles. It will highlight because it is finding FR within the abbreviation CFR.
If I change it to look for (FR) then I only get C17 highlighted, but I would still want C11 highlighted.
The only way I can figure to do this is create several more helpers cells to text join so that C11 and all other cells would look like
• Produce Approved for Permit (AFP) Drawings - (TR) (FR) (DD) |
This is an easy fix, but that it changes the one one tab looks/reads compared to all the other tabs and documents.
Is there anyway to get it to search only after the hyphen or within the parentheses?
One of you genius' out there may have a solution. I'm hoping conditional formatting will still work and not resort to adding VBA. Thanks so much.