Conditional Formatting Question

[nlege051]

I am working with 3 columns and need the following things to happen:

1) If a cell in column F contains a date, the cell in column G should add 5 business days to this date (due date). Column G should be empty if there is no entry in column F.
2) If the date in column G has passed, the cell should turn red. If the date has passed but there is a date in column H, the cell should not turn red.

I managed to figure out some of the formatting thanks to this forming but I can't make it all work at the same time.

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/965122-help-conditional-formatting.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).