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
 

Fluff

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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,132
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.
 

Forum statistics

Threads
1,077,668
Messages
5,335,579
Members
399,026
Latest member
Im_Stupid

Some videos you may like

This Week's Hot Topics

Top