Conditional Formatting based on two cell values Solved/Closed

Question

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.

Mazzaropi · Answer

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

JamesA82 · Answer

Worked perfectly, thank you Marcilio this will be very helpful for me.

Mazzaropi · Answer

JamesA82, Good morning.

Thanks for the feedback.

Glad to help you. 
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Conditional Formatting based on two cell values

3 responses

Similar discussions

Subscribe To Our Newsletter!