Windows 7, Excel 2007. Could anyone write a macro to delete all the conditional formatting on the worksheet, then apply conditional formatting to column A that will fill in the interior color (any color would be fine, just not clear) with the formula =AND($D1<>"",$A1=""). The macro recorder is not getting the formula right, thanks. Names don't matter, I will be pasting it into another macro.