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...

=NOT(ISBLANK($Q4))

Thanks!


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