+ Reply to Thread
Results 1 to 7 of 7

Highlighting range of cells

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    Highlighting range of cells

    I'm designing a day to day appointment intake diary for a vehicle training company.

    I have attached a screenshot of the set up i have below to simplify things.

    The dropdown menu's is of the instructors and the cells below will be of the appointments and customers they have that day.

    In the cell next to CBT i want to make it that the user can either enter Y/N:

    If Y is entered all the cells in that instructors columns for that day will turn red which means there not available for appointments.

    If N is entered all the cells will turn green which means they are available for appointments.

    i plan to use autofill to add as many additional days as i can while bringing the formatting with it.

    how would i go about this?

    i'm still quite new to excel so be as detailed as possible.

    I really appreciate any help i can get!
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Highlighting range of cells

    It will be good if you attach a sample excel file instead of a png.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Highlighting range of cells

    Hi

    You will need Conditional formatting for this

    Hiqhlight for example range D4:D100 and in CF rules, put this.

    =$d$2="Y") Choose red color. Same way for Green.

    Is this, works for you?

    If you can not handle this, pls, upload a small sample workbook.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    05-29-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Highlighting range of cells

    Apologies, here's a sample worksheet
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-29-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Highlighting range of cells

    Thanks for the help fotis1991 i got it to work!

    Is there any way i can copy this formatting down on to my next day and keep going instead of having to enter in the formatting manually for each day?

  6. #6
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Highlighting range of cells

    Where next starts? In A26?

  7. #7
    Registered User
    Join Date
    05-29-2012
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Highlighting range of cells

    next start will be A54 as i have other information under each day that does not need formatted

    i have added my updated worksheet below

    I have just added the Y=red option for now until i get the hang of it.
    Attached Files Attached Files

+ 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