hi

I am currently doing a spreadsheet by excel.

I am thinking of 1 worksheet that holds all the data like a database.
Then in the other sheets are the sorted and processed sheets to show
data extracted.

Lets call my database "DATABASE" and first worksheet would be "Shipping
Schedule"

First problem:

for each row in Shipping Schedule worksheet, if under the REMARKS
column is a "shipped"
I would like to change the font of the whole row automatically to red
words.

Conditional formatting does not seem to work for me as it does not seem
to run for each row. I believe, I will need a loop to do this. Can
someone help me with this?

Problem 2:
when I open Shipping schedule, I like it to sort automatically by date
as well under columns call "Fty ETD", then "buyer Etd", then "price" in
order of priority.

this is because, our clerks will be typeing in data in the DATABASE
worksheet and when they click on Shipping Schedule worksheet, all the
info would be there and sorted automatically without doing it manually.

pls help. Thanks!