I'm trying to format a spreadsheet so past dates in column F appear in red.

column E column F
[Date] entered Date+30

I've added this formula to the second column:
=IF(E3+30<=TODAY(),[Red](E3+30),(E3+30))

but it's not working. I've fiddled with the formula to the point where all
results appear in red, but I can't manage to get the column to do what I
want. I've tried to use conditional formatting but again, it makes all
results appear in red. Does anyone know what I'm doing wrong?

Mary