Hello, I would like help with a Macro that would format a row based on the following:

Color the entire row RED (font color: White) if any cell in Column 1 = “Active” AND Due Date is 6 months away from TODAY().

Stay RED (font color: White) until any cell in Column 1 changes to Inactive (or any other text or blank) or Due Data changes to a date further than 6 months away from TODAY().

Thank you for your help!