Thanks all. This worked.



"Claus Busch" wrote in message ...

Hi,

Am Tue, 22 May 2012 14:27:46 -0400 schrieb Saucer Man:

I am currently filling in the entire row Yellow if the cell in column Q
doesn't have anything in it. I want to fill with a different color if the
first characters in the cell are "Shipped". How do I do this? I am using
the following formula to fill it yellow...

try:
=SEARCH("Shipped",$Q4)=1
or
=LEFT($Q4,7)="Shipped"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2


--- Posted via news://freenews.netfront.net/ - Complaints to ---