Report

Conditional Formatting based on two cell values [Solved]

Ask a question JamesA82 2Posts Friday March 31, 2017Registration date April 2, 2017 Last seen - Last answered on Apr 3, 2017 at 10:34 AM by Mazzaropi
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 
Helpful
+1
plus moins
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
Leave a comment
Helpful
+0
plus moins
Worked perfectly, thank you Marcilio this will be very helpful for me.
Leave a comment
Helpful
+0
plus moins
JamesA82, Good morning.

Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!