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

Report
Posts
2
Registration date
Friday March 31, 2017
Status
Member
Last seen
April 2, 2017
-
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
-
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.

3 replies

Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Friday March 31, 2017
Status
Member
Last seen
April 2, 2017

Worked perfectly, thank you Marcilio this will be very helpful for me.
Posts
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
JamesA82, Good morning.

Thanks for the feedback.

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