Conditional Formatting for Multiple Conditions

[AJuarez5032]

Hello,

I am attempting to use conditional formatting to change the color of cell O6 if G6 contains the word “Yes” and O6 contains any date.

The formula I am using is:
=AND($G6=“Yes”,$O6<>””)

Unfortunately, no success

 

[Joe4]

Welcome to the Board!

It works just fine for me. Just note that Excel does not linked slanted double-quote marks, they need to be the straight up and down ones like this:

=AND($G6="Yes",$O6<>"")

If you still cannot get it to work, please lay out the details for us.
What cell are you trying to apply this formula to?
And can you show us a screen print, like I did above, so we can see cells G6 and O6?

 

[AJuarez5032]

Welcome to the Board!

It works just fine for me. Just note that Excel does not linked slanted double-quote marks, they need to be the straight up and down ones like this:

=AND($G6="Yes",$O6<>"")

View attachment 121147

If you still cannot get it to work, please lay out the details for us.
What cell are you trying to apply this formula to?
And can you show us a screen print, like I did above, so we can see cells G6 and O6?

Does it matter if the word “Yes” is in a drop down list on cell G6?

 

[Joe4]

No, not at all. But just make sure that it equals EXACTLY "Yes".
If there is so much as an extra space at the beginning or end of "Yes", it won't work.

Are you sure that you applied your Conditional Formatting rule to the correct range?
This is a very common error people make, as they do not always understand the correlation between the applied to range and formula they enter.

 

[AJuarez5032]

Does it matter if the word “Yes” is in a drop down list on cell G6?

Yes

 

[AJuarez5032]

Okay, let ne

No, not at all. But just make sure that it equals EXACTLY "Yes".
If there is so much as an extra space at the beginning or end of "Yes", it won't work.

Are you sure that you applied your Conditional Formatting rule to the correct range?
This is a very common error people make, as they do not always understand the correlation between the applied to range and formula they enter.

Wow thank you!!! I have been trying to solve this issue for about 2 weeks & the reason is wasn’t taking was due a space after the word “Yes.” I truly appreciate your help!!

 

[Joe4]

You are welcome.

Note, if it is just a regular space, and not some special character (like a "non-breaking space"), you could also address it by changing your formula to this:

=AND(TRIM($G6="Yes"),$O6<>"")

as the TRIM function would drop regular spaces at the end.

 

[Joe4]

Note that when marking a post as the solution, you want to mark the original post that contains the solution (not your own post acknowledging some previous post is the solution).
I have updated this for you.