How to conditionally format cells using partial text

Hi there,

I want to use the conditionally format tool, specifically the one titled "Use a formula to determine what cells to format".

I have a list of departments and their locations, i want the conditional format to use the cells in column H based on partial text.

I currently use the following formula:

=$H1="50 Martin Place"

It works on the cells that only show '50 Martin Place' however i have other cells that actually show 'Level 2, 50 Martin Place' and other floors. I want it to format these cells too, anything that contains '50 Martin Place' in the cell.

I use this conditional format as it then highlights the cells on either side of column H, this part i can fix up easily, i just don't know how to write the formula correctly, i tried using "*50 Martin Place*" but it didn't work.

Many thanks

Hi ELeGault,

Thanks for the information but i already mentioned i had done that and it doesn't work. I placed an asterisk one in front, one behind and one in front and behind and none of those options helped.