CF1: Formula is =AND(LEN(B1)=0,A1<"",A1<TODAY())
Format1: <patterns/<red

CF2: Formula is =AND(LEN(B1)=0,A1<"",A1<(TODAY()+7))
Format2: <patterns/<yellow

In article ,
Pete Sperling wrote:

JE McGimpsey - Your suggestion works great - How would I add a third
condition which leaves cell A1 with no color if the Due date cell is null.
I'm trying to prevent having to enter the conditions in the Due date cells
each time I add a new action item to the list.