I have a spreadsheet which is set up to track a schedule based on dates. I
have two rows; top for a projected date (static) - bottom for an actual date
(varies).

This schedule is tracked daily, therefore I have the TODAY() function in the
bottom rows. I would like the following to happen:

NOT COMPLETE - NOT AFFECTED:
If the bottom "actual date" cell contains the TODAY() function and is equal
to or less than the top "projected date" cell, I would like the cell to be
formatted white cell/white text.

NOT COMPLETE - BEHIND SCHEDULE:
If the bottom "actual date" cell contains the TODAY() function and is
greater than the top "projected date" cell, I would like the cell to be
formatted red cell/red text.

COMPLETE - ON SCHEDULE:
If the bottom "actual date" cell contains an entered date which is equal to
or less than the top "projected date" cell, I would like the cell to be
formatted yellow cell/green text.

COMPLETE - BEHIND SCHEDULE
If the bottom "actual date" cell contains an entered date which is greater
than the top "projected date" cell, I would like the cell to be formatted
yellow cell/red text.

I'm thinking that I have too many variables for conditional formatting. I
also attempted to use the AND function within the conditional formatting and
was unsucessful. PLEASE help if you can... this schedule is what's driving
our company and it's currently a management headache. Any info is
appreciated!!!

--
Thanks in advance! -T