I’m wondering what the benefit is in having a cell which you use for dates to be in anything other than a date cell. Do you not wish to use any of the pre-formatted options on dates that Numbers offers? In any case if you set the cells to be dates the conditional formatting is pretty easy. Here, green is past, white is today and orange is future. (Forgive me, I’m from Ireland)
