K
KidA
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
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