My google fu is weak today, hoping someone on here may be able to help.

I am trying to format an excel sheet so that if a date appears in column G then the status column C changes from Open to Closed.

I am hoping this is not too complicated and someone who uses Excel on a more regular basis than myself can help.

Thanks

Rusty.

convert the date to Universal time code them > if thingy

Not perfect, as someone entering “12345” would do the same, but:

In “C2″ enter =if(and(isnumber(G2),len(g2)=5),”Closed”,”Open”)

Or, if using current dates, rather than historical ones:

=if(and(g2>41000,g2<43000),”Closed”,”Open”)

rondo,

Just for clarity i should enter the formatting on Column C

Currently i had Column G formatted with the following but it doesn’t work “=AND(E2=”<TODAY()”,$C$2:$C$229=”Close”)”

Will clear mine and try yours

Enter the formula in C2 & drag down as far as your corresponding data.

Ok so i messed up in my innitial post dates were in column E

However Rondo FTW

got it to work when i swapped the G’s to E’s in his code. Thank you very much sir.