Hi,
I'm trying to apply conditional formatting to a cell when it contains "RTW" Doing it on a column of cells where a cell ONLY contains "RTW" is easy, but if the cell also contains other words such as Europe, Africa etc, then I'm stumped.
Sample cells (straight copy and pasted)
-----------
RTW
"RTW Africa Europe"
Africa
Europe
Asia
-----------
The second row contains three values, separated by tabs. That's the hard one. Of course there are other similar cells.
Anyone have any ideas?
Thanks for any help!
Grant
I'm trying to apply conditional formatting to a cell when it contains "RTW" Doing it on a column of cells where a cell ONLY contains "RTW" is easy, but if the cell also contains other words such as Europe, Africa etc, then I'm stumped.
Sample cells (straight copy and pasted)
-----------
RTW
"RTW Africa Europe"
Africa
Europe
Asia
-----------
The second row contains three values, separated by tabs. That's the hard one. Of course there are other similar cells.
Anyone have any ideas?
Thanks for any help!
Grant