Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: conditional formatting

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I change the background on a group of cells base on data in each cell.

    I am creating a monthly schedule and would like to pick a persons name from a list and have it highlite the days they are listed on.
    I have 31 days down and a max of 5 persons per day across.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,613
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-13 03:01, Jaugenblick wrote:
    How can I change the background on a group of cells base on data in each cell.

    I am creating a monthly schedule and would like to pick a persons name from a list and have it highlite the days they are listed on.
    I have 31 days down and a max of 5 persons per day across.
    Make a list of the relevant persons in a sheet you could name Admin. Select all of the names of this list, go to the Name Box, type NAMES, and hit enter.

    Go to the sheet where you have that 31 days-schedule. If row 1 is not free, insert a row before the first row your data.

    Activate say A1 in row 1.
    Activate Data|Validation.
    Select List for Allow.
    Enter as Source:

    =NAMES

    Activate OK.

    Now select the schedule range (I'll assume here: B3:F100).
    Activate Format|Conditional Formatting.
    Choose Formula Is for Condition 1.
    Enter as formula:

    =B3=$A$1

    Activate Format.
    Select a color to your liking on the patterns.
    Activate OK, OK.


  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the help it worked great.

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
  •