Forum Discussion
whydoe1336
Feb 09, 2024Copper Contributor
Conditional Formatting Help
I feel silly even having to ask this but I am stuck.
I am trying to format an entire row based on text in a cell. The only problem is it’s based on some of the text in the cell (i.e. the cell contains “ROA-John Smith” but I want to format based on just “ROA”.)
Is this something excel can do and if so what formula would I need?
- Riny_van_EekelenPlatinum Contributor
- whydoe1336Copper ContributorThat’s perfect! Thank you so much!