Previous Topic Next Topic

Conditional Formatting based on two cell values

Solved/Closed
JamesA82 Posts 2 Registration date Friday March 31, 2017 Status Member Last seen April 2, 2017 - Mar 31, 2017 at 01:45 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.

3 responses

Answer 1 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 31, 2017 at 03:06 PM
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
Answer 2 / 3
JamesA82 Posts 2 Registration date Friday March 31, 2017 Status Member Last seen April 2, 2017
Apr 2, 2017 at 06:00 PM
Worked perfectly, thank you Marcilio this will be very helpful for me.
Answer 3 / 3
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Apr 3, 2017 at 10:34 AM
JamesA82, Good morning.

Thanks for the feedback.

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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses