Welcome to the Board, Bob!
Take a look at Format-->Conditional Formatting.
For the first one, in the cell that houses the date you want formatted, you can use Condition 1-->Cell Value Is-->Greater Than-->The cell with the starting date. Format Patterns as Red.
For the second one, you can use a SUMIF formula, like =SUMIF(W1:Z1,A1) in a seperate cell.
Conditional Format Cell A1-->Condition 1-->Cell Value Is-->Not Equal To-->The Cell where the SUMIF is located. Format Patterns as Red.
Hope that helps,
Smitty