qazinomi,
I just put your words into a formula:
Put =TODAY() in A1
Put an earlier date in A3:A4
Put today's date in A5:A6
Put a later late in A7:A8
Put nothing in A3,A5,A7
Put a number in A4,A6,A8
In C3 put =IF(A3<$A$1,"<",IF(A3=$A$1,"=",""))
and copy down to C8
In D3 put =IF(A3<$A$1,IF(B3="","argent","paid"),IF(A3=$A
$1,IF(B3="","Due Today","paid"),"Due later"))
and copy down to D8
Do the red with conditional formatting.
I hope this helps, Dave