Hi, I have simple to do list in a table with one rule in Conditional Formatting. If the text within cells D5:D19 are changed to "Completed", the entire row should color green. Somehow once the Conditional Formatting is applied the alignment is also changed. I already tried to save the Excel file in a different format (.xls, .xlsm, etc.), but it doesn't change anything.