L
Legacy 469343
Guest
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.
![2.PNG 2.PNG](https://www.mrexcel.com/board/data/attachments/29/29461-e903c347b6eae00d2ee47830b4dff9a7.jpg?hash=6QPDR7bq4A)
![1.PNG 1.PNG](https://www.mrexcel.com/board/data/attachments/29/29460-8a26b42671359193b307ceb0556a6526.jpg?hash=iia0JnE1kZ)
![2.PNG 2.PNG](https://www.mrexcel.com/board/data/attachments/29/29461-e903c347b6eae00d2ee47830b4dff9a7.jpg?hash=6QPDR7bq4A)