+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting with autofilter

  1. #1
    Registered User
    Join Date
    03-25-2009
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Conditional formatting with autofilter

    Hi,

    This site has already helped and I've only just joined.

    I am however needing help as I can't find how to do this anywhere.

    I am making a work holiday sheet and I have the staff names (21), depts (7), and months (12) all on autofilter. I then have 1-31 days along the top for each month.

    I have been asked to put conditional formatting when certain depts all have holidays at the same time. i.e. if i chose the IT dept for April which has 4 staff and they are all wanting the 10th April off can this show up the colour red say.

    I have been trying some IF statements but can only do one cell at a time which is no use.

    Any help would be greatly appreciated as I have spent all day without any joy.

    I was also doing drop down menus for the names, depts and date but this was getting too complicated for one sheet so I went for the autofilter which is pretty easy.

    Cheers,
    John

  2. #2
    Registered User
    Join Date
    03-25-2009
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Conditional formatting with autofilter

    No one got any ideas or can't this be done?

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Conditional formatting with autofilter

    can you post example?

  4. #4
    Registered User
    Join Date
    03-25-2009
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Conditional formatting with autofilter

    This is what I have before I use the autofilter:

    http://www.isdscotland.org/isd/5925.html

    I want to be able to pick a team from the autofilter (here I have picked team 1) and if say they all have holidays on a same day then I want to highlight them in red or a colour.

    Cheers,
    Last edited by johnnyk39; 03-27-2009 at 06:06 AM.

  5. #5
    Registered User
    Join Date
    03-25-2009
    Location
    scotland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Conditional formatting with autofilter

    Does anyone know or should this maybe be in VBA section for a macro?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1