Nadberb525
New Member
- Joined
- Jun 14, 2019
- Messages
- 1
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![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)