This content has been marked as final. Show 2 replies
I have been trying to figure out how to create a conditional format in one field that will only format something that is contained within parentheses (brackets, or a specific instance, i.e., TBD)
I have no problem creating the conditional format to highlight a field.
Here are two examples.
The first example I have the conditional format of: Value is containing "TBD" Highlight
What I would like is for only the letters TBD to be highlighted, as shown below (I did this in illustrator to show what I am looking for)
The next instance, I would like to make different parentheses (brackets, or a specific instance, i.e., NEW) to be formatted (see above).
So if an instance is contained in parentheses the copy is changed to bold orange, the "new insert" is left alone.
Bonus points: You can have it format different lines based on that line containing a specific word instead of between brackets as shown.
Thank you very much for any help you can provide.
Also, as I am new to the boards, I searched for my answers (and online) but came up empty handed. I am more geared to WYSIWYG vs "code" and that may be downfall, but I am totally excited to see how I can make FMP work for me. I have already learned things that will save my team and I a tremendous amount of time! Simple... but Leftwords / Rightwords = amazing!