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?

 

[MARK858]

Maybe...

=AND(NOT(COUNT(SEARCH("*+*",$A2))),($D2=TRUE))

 

[Oshia]

Hi,

I've tried that, and it's not working. Basically I am trying to get an accurate guest list count, I've thrown a sample range below. My plan has been to have any cell that correlates to two people be a different colour so I can count the cells based on colour, not easy, and then double the number given for cells associated with 2 people. I don't know if anyone might have an suggestions on easier ways to do that or something different to get my original question working.

Guest	RSVP
Alice	TRUE
Bobby + 1	TRUE
Carol + Dean	TRUE
Ella	FALSE

 

[MARK858]

I've tried that, and it's not working

Works for me

Book2
	A	B	C	D
1
2	Alice			TRUE
3	Bobby + 1			TRUE
4	Carol + Dean			TRUE
5	Ella			FALSE
6	Ella			TRUE
7	Ella+			TRUE
8
9
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D7	Expression	=AND(NOT(COUNT(SEARCH("*+*",$A2))),($D2=TRUE))	text	NO

 

[Oshia]

Hiya,

My apologies, I had two ==, It's way too late for this. Thank you so much for your help it works perfectly fine. Have a great evening!

 

[Micron]

Or?
=AND(IF(FIND("+",A1,1),D1=TRUE))

 

[MARK858]

Deleted because I didn't realise the range had been changed

 

[MARK858]

Thank you so much for your help it works perfectly fine.

Happy we could help and welcome to the forum

@Micron the OP is looking for doesn't find +

 

[Micron]

@Micron the OP is looking for doesn't find +

Sorry, don't understand that. To me, OP means original post, or original poster depending on the context. When I read that either way it doesn't make sense to me. Are you saying OP is not looking for a plus sign in a string in a cell? I thought that was the case and what I wrote worked for me as a CF rule.

 

[MARK858]

Are you saying OP is not looking for a plus sign in a string in a cell? I thought that was the case and what I wrote worked for me as a CF rule.

That is exactly what I am saying, the OP (either original poster or original post) request is

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?

The formula you posted for me highlights the cells that do have a + sign in column A and a TRUE in column D

Book1
	A	B	C	D
1	Alice			TRUE
2	Bobby + 1			TRUE
3	Carol + Dean			TRUE
4	Ella			FALSE
5	Ella			TRUE
6	Ella+			TRUE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D1:D6	Expression	=AND(IF(FIND("+",A1,1),D1=TRUE))	text	NO