I have a conditional formatting formula that changes a cell color in Column H based on if the cell in Column F contains "NO":
Format of Column F data:
AA–DD MMM YY–YES or AA–DD MMM YY–NO
Examples of Column F data:
MC–13 Oct 17–YES
MC–14 Oct 17–YES
MC–31 Oct 17–NO
Conditional Format formula:
This formula has been working fine until we hit November, whereby the month also contains "No" so the formula is no longer working properly:
MC–01 Nov 17–YES
MC–01 Nov 17–NO
I need to revise the conditional format formula so it is case sensitive, so it only detects 'NO' in all capital letters:
=ISNUMBER(SEARCH("*NO*",$F2)) 'this formula needs to be case sensitive, detecting only 'NO' and not 'No'
I have attached a sample spreadsheet.