Conditional formatting for when one cell does not contain a + and another does = true.

[Oshia]

Hiya,

I'm attempting to change the colour of Cell D based on if Cell A doesn't contain a + symbol and Cell D = true, I've managed something similar for when it Cell A does contain a + using the following formula in the conditional formatting =AND(COUNT(SEARCH("*+*",$A2)),($D2=TRUE)) applied to =$D$2:$D$150, I just need, I suppose, the opposite of the first condition. Any ideas?

 

[Micron]

Thanks! I forgot about the request to do the opposite.

 

[MARK858]

No problem