I should have said with A1 the activecell.

But glad you figured it out.

MatthewTap wrote:

Dave --

Thanks... I went with the first one, changing the conditional format to
Formula, and one thing I didn't know but figured out by your posts is that I
could put in A1 for the formula template and it took care of the rest of them.

In any case, thanks... my problem solved. I appreciate your time.

"Dave Peterson" wrote:

If you only care if there's the characters "CAR" in the cell, you can use:

=countif(a1,"*car*")0
or
=countif(a1,"*"car*")
(0 is treated as false)
or

=ISNUMBER(SEARCH("car",A1))
or even
=SEARCH("car",A1)
(an error will be treated as false)

Be aware that "Dodge Caravan" will look like a car in all of these.


MatthewTap wrote:

I am new to the MS forums; I apologize if I am breaking etiquette of any
sort, but I'm looking for some help.

I'm wondering if there's any way when using Conditional Formatting to have
it specify if the cell contents are 'like' something.

For example, if I have entries in a column such as:
Red Car
Blue Car
Yellow Truck
Blue SUV
Yellow Car (convertible)
Black Pick-up

etc... and I want to make anything that's a car in that list formatted so
it's Bold.

And again, this is just an example, but if there's anything else I can help
clear up about it... I'd really like to know if this is possible.

Thank you very much for your time.
Best regards,
Matt

--

Dave Peterson


--

Dave Peterson