Conditional Format with Search and Days

Gliffix101

Board Regular
Joined
Apr 1, 2014
Messages
74
Hello,

I'm attempting to add conditional formatting to a sheet. The Conditional Format is based on:

1) Column A contains the word "Sales" AND Column C is < 30
2) Column A does not contain the word "Sales" AND Column C is < 90

I attempted to build out the formula, but it does not work as expected.

=AND(ISNUMBER(SEARCH("Sales",A1)),C1<"30")

Thought?

Thanks,
Gliff
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,785
Office Version
365
Platform
Windows
What happens if you remove the quotes from the 30?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,785
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback.

For reference with the quotes the formula is looking for a text value, rather than a number.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,781
Messages
5,446,464
Members
405,403
Latest member
horace james

This Week's Hot Topics

Top