Conditional formatting based on multiple criteria from two different cells

[Via7338]

Hello,

I am trying to create a conditional formatting rule that will highlight the cell if one column contains the text "Closed Won" and another column contains the text "Fruit". I am using this currently...

=AND(ISNUMBER(SEARCH("Closed Won", $D4)),ISNUMBER(SEARCH("Fruit",Sheet4!$AF3)))

but it doesnt seem to be working.

Thanks!

 

[Joe4]

Welcome to the Board!

Which version of Excel are you using?
Note that the ability to use other worksheets in Conditional Formatting and how that is accomplished may be different, depending on which version you are on.
See: http://blog.contextures.com/archives/2010/09/03/conditional-formatting-from-different-sheet/

 

[Via7338]

Welcome to the Board!

Which version of Excel are you using?
Note that the ability to use other worksheets in Conditional Formatting and how that is accomplished may be different, depending on which version you are on.
See: http://blog.contextures.com/archives/2010/09/03/conditional-formatting-from-different-sheet/

I am using Excel 2016 office 365

 

[Joe4]

Your formula seems to work for me.

I can try to recreate your scenario, if you answer these questions:

What sheet and cell is this Conditional Formatting being placed?
What exactly is in cell D4 of that sheet?
What exactly is in cell AF3 on Sheet4?