Conditional Formatting based on two cell values [Solved/Closed]

JamesA82 2 Posts Friday March 31, 2017Registration date April 2, 2017 Last seen - Mar 31, 2017 at 01:45 AM - Latest reply: Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen
- Apr 3, 2017 at 10:34 AM
Hi There,

I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a condition that the cell in column D (same row that DEMO is detected) is LESS THAN 15.

If both conditions are met, the cell in Column D should be highlighted Orange.

Many thanks for your help.
See more 

3 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 31, 2017 at 03:06 PM
1
Thank you
JamesA82, Good afternoon.

Select cells at colunm D to apply the CF.

Suppose: D2:D100
Menu Conditional Format
Using Formula
=AND(NOT(ISERROR(SEARCH("*DEMO*", $A2))), $D2<15)

Select colour format as desired
OK

Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1714 users this month

JamesA82 2 Posts Friday March 31, 2017Registration date April 2, 2017 Last seen - Apr 2, 2017 at 06:00 PM
0
Thank you
Worked perfectly, thank you Marcilio this will be very helpful for me.
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Apr 3, 2017 at 10:34 AM
0
Thank you
JamesA82, Good morning.

Thanks for the feedback.

Glad to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão