If / Then using the red, yellow, green

I am new to Smartsheets, so this may be a basic knowledge question ...

I'm trying to use the red, yellow, green, (really just red and green) for the following scenario ...

Start date is 10/1/20, due date is 10/6/20, another column for completed date.

Using the completed date if it is <due date, then green, if it is finish date, then red. Here is what I have . The green works, but I can't get the red to display.

=IF(Completed7 < Due7, "Green"), IF(Completed7 > Due7, "Red")

Thank you in advance !

Best Answers