Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Conditional formatting

  1. #1
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good Morning,

    I have in row 1 dates, 1,2,3 etc.
    In row 2 I have days, mon, tue, wed, that corresponds to row 1. In row 3, I would like to shade days off, and not necessarily sat/sun, but also mon/tue etc. The month does not matter. Can the shading be done by using a condtional format, instead of clicking the cells and formatting them manually? Mahalo.....

    Brian



    [ This Message was edited by: Brian from Maui on 2002-02-24 07:00 ]

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

    Default

    On 2002-02-24 07:00, Brian from Maui wrote:
    Good Morning,

    I have in row 1 dates, 1,2,3 etc.
    In row 2 I have days, mon, tue, wed, that corresponds to row 1. In row 3, I would like to shade days off, and not necessarily sat/sun, but also mon/tue etc. The month does not matter. Can the shading be done by using a condtional format, instead of clicking the cells and formatting them manually? Mahalo.....

    Brian



    [ This Message was edited by: Brian from Maui on 2002-02-24 07:00 ]
    You can have at most 3 conditions/colors thru Format|Conditional Formatting. There is some VBA code to go beyond that limit, which you can uncover from the Archives.

    Aladin

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    As you well know, my knowledge of formulas and Excel is very limited, doing VBA codes is something I'd like to avoid. I'm trying different IF functions.

    Brian

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

    Default

    On 2002-02-24 07:43, Brian from Maui wrote:
    Aladin,

    As you well know, my knowledge of formulas and Excel is very limited, doing VBA codes is something I'd like to avoid. I'm trying different IF functions.

    Brian
    If 3 colors are sufficient for your purpose, it's doable with ordinary cond format.

  5. #5
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    Actually, I only need one color. And only two conditons. If a2="mon and b2="tue, then color a3 and b3, but my range is from a2:o2. Make sense. I'm trying a countif and if functions.

    Brian

    [ This Message was edited by: Brian from Maui on 2002-02-24 07:59 ]

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

    Default

    On 2002-02-24 07:57, Brian from Maui wrote:
    Aladin,

    Actually, I only need one color. And only two conditons. If a2="mon and b2="tue, then color a3 and b3. Make sense. I'm trying a countif and if functions.

    Brian
    Select A3:B3.
    Activate Format|Conditional Formatting.
    Choose Formula Is for Condition 1.
    Enter in the Formula Box:

    =AND($A$2="mon",$B$2="tue")

    Activate Format.
    Choose a color on the Patterns tab.
    Click OK, OK.

  7. #7
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    The =and doesn't work. I've used in a3
    countif(a2:o2,"mon") and that works for one cell, but copy and pasting along the rows, colors the whole row.

    Brian

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

    Default

    On 2002-02-24 08:25, Brian from Maui wrote:
    Aladin,

    The =and doesn't work. I've used in a3
    countif(a2:o2,"mon") and that works for one cell, but copy and pasting along the rows, colors the whole row.

    Brian
    I notice you're changing your specs.

    What do you want exactly?

    Is it, If a2="mon" and b2="tue", (a) color a3 and b3 as you intially stated or (b) color row 3?

    If (b), select row 3 by clicking the row indicator, apply the proc I described.


  9. #9
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    What I want is:
    if a2=mon,b2=tue, color a3 and b3.
    Then I need to drag the format for the whole work month.
    I've selected a3 and b3, put the formula in, selected a color, but the cells are still blank.

    Brian

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi brian how the coast sunny i bet! Rain and RAIN!

    Lokk if you need some VBA code can i help i have 25 or so conditions that work at a snal subject to col data i wanted line / row coloured...

    If so email me at my work you have me email and send the sheet ill have a look and sed back

    Rdgs

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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
  •