Update font color and another field based on formula

[ba4crm]

In an Excel sheet, I have Columns Date Due, Date Paid, Status. What I want to do is:
If Date Paid = "" and Date Due > current date, change row font to red and insert "Over Due" under status.
If Date Paid <>"" and Date Due > Date Paid, change row font to yellow and insert "Late Pmt" under status.
To acheive the first part (changing font), I used conditional format formula [=(AND($E4="", $D4>TODAY()))]
and [=(AND($E4="*", $D4>$E4))]. However, I cannot do the updating another field or adding more criteria
with conditional formatting. Is it possible to do this in VBA? Any help would be appreciated.

 

[SkipVought]

Hi,

Check out Format/Conditional Formatting. You can specify up to 3 criteria for 3 different formats.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}