Conditional Format with Search and Days

[Gliffix101]

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]

What happens if you remove the quotes from the 30?

 

[Gliffix101]

Oh you have got to be kidding me LOL

Thank you for the answer.

 

[Fluff]

You're welcome & thanks for the feedback.

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