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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,599
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,599
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,430
Messages
5,444,413
Members
405,281
Latest member
JCOOK243

This Week's Hot Topics

Top