Excel wizzards conditional formatting of columns HELP please.

Home Forum Chat Forum Excel wizzards conditional formatting of columns HELP please.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Excel wizzards conditional formatting of columns HELP please.
  • Premier Icon mikewsmith
    Subscriber

    convert the date to Universal time code them > if thingy

    rondo101
    Member

    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”)

    Premier Icon Rusty Mac
    Subscriber

    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

    rondo101
    Member

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

    Premier Icon Rusty Mac
    Subscriber

    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.

    Premier Icon Rusty Mac
    Subscriber

    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.

Viewing 6 posts - 1 through 6 (of 6 total)

The topic ‘Excel wizzards conditional formatting of columns HELP please.’ is closed to new replies.