hi
i need help in creating formula

lets suppose a cell A6 have a date in it. and cell A7 have some number

in cell A8 i want to insert a formula that tell me if A6 have previous date and A7 is empty then A8 show "argent" in red color. if A7 have number then it shows "paid"
if date is today and the A7 is empty then A8 show "Due Today". if A7 have a number then "paid"
if the date is in future then then it shows "due Later"

Thank you

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