I have tried these formulas but doesn't work...please help.
cell E4 has a due date (5 Oct 2017)

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=6) for orange



=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>=3) for blue

=AND($F4<>"Paid",TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),$E4)>0) for green

Perhaps =AND($F4<>"Paid",(TODAY()-$E$4)>=6)
etc.. and check "Stop..." (don't remember the line..

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Please see attached sample sheet.

Attached Files

sample-sheet.xlsx (10.6 KB, 11 views)