'Multi conditional formatting based on dates

I need to format columns D, F, G, H, & I based on a date entered into column C Formatting needs to highlight any cell in those columns that are blank.

Column D needs to highlight based on Column C +5-29 days.

Column F, H, & I highlight based on Column C +30, +60, +90 days respectively

Column G highlight based on Column C +31-60 days

Once a date is entered into a cell in those columns I need the formatting to clear.

Any help would be greatly appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source