Applying Color codes to Smartsheet Rows

Vikram Grover

I have Due Date and Work Completion Date columns. I need to apply following color codes-

1. If Work completion date is less than or equal to Due Date, entire row should become Green
2. If Work completion date is greater than Due Date, entire row should become Red

What conditional formatting should I apply? Please advise.

Thao Tran Phuong

you can insert a column and make this formula (hide this column cause don't need to show):

(Completion date cell) minus (due date cell). Then conditional formating can be: if < 0 then red; >=0 then green.

Vikram Grover

Thank you. It worked !