Help with SEARCH AND function

[Nadberb525]

Hi,

I am trying to get my excel spreadsheet to highlight rows containing the word ‘June’ in column C1 when I have ticked my checkbox. I have my checkbox linked to cell N11 via conditional formatting so my formula at the moment is AND($C1=‘June’,$N$11)

However, this is returning (when my checkbox is ticked) no rows highlighted because in column C1 my cells contain for example ‘13 June 2019’ and not just the word ‘June’. Therefore I want to know how I can add a SEARCH/FIND to the above formula that would allow my rows to be highlighted when June appears in the row. Perhaps something like SEARCH(AND($C1=‘June’,$N$11)?

Any help would be greatly appreciated

 

[Fluff]

Do you have dates in col C that are formatted to show 13 June 2019, or is it actual text?