Conditional Formatting
Results 1 to 4 of 4

Thread: Conditional Formatting
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular bill351's Avatar
    Join Date
    Jan 2009
    Posts
    83
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Conditional Formatting

    I Have an attendance sheet that a list of staff, staff times and a list of reasons for non attendance.

    What I am trying to accomplish is when a staff member does not show for work I can pick the reason why "SICK" and their name changes to red and strikethrough. the current formula is =$D$6="SICK" however I need this to take in account ALL 5 reasons
    SICK
    TOIL
    REC
    ATW
    COS

    I have tried a few variations but can't get the whole list to work ??

    Cheers
    Bill from OZ

  2. #2
    Board Regular somnath_it2006's Avatar
    Join Date
    Apr 2009
    Location
    Pune, India
    Posts
    574
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting

    Try this in conditional formating formula:

    =IF(OR(D6="SICK",D6="TOIL",D6="REC",D6="ATW",D6="COS"),TRUE,FALSE)
    Regards,
    Som



    The more we come out and do good to others, the more our hearts will be purified, and God will be in them.” - Swami Vivekananda

  3. #3
    Board Regular bill351's Avatar
    Join Date
    Jan 2009
    Posts
    83
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting

    Thank you somnath it2006 that worked

    strangly REC doesnt however all the others work just fine I will play to see why

    Again thank you

  4. #4
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,449
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formatting

    =OR(D6="SICK",D6="TOIL",D6="REC",D6="ATW",D6="COS") will surfice
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •