 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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.