+ Reply to Thread
Results 1 to 3 of 3

Bottom border and Yellow pattern in Condition formatting

  1. #1
    Registered User
    Join Date
    07-11-2009
    Location
    London
    MS-Off Ver
    Excel 2000
    Posts
    12

    Bottom border and Yellow pattern in Condition formatting

    I have posted in the Excell Programming section but so far no advice:-

    http://www.excelforum.com/excel-prog...ml#post2134597

    But am now trying this using Conditional Formatting in Excell 2000; so limited to 3 conditions.

    However I cannot get it work with multiple conditions:-

    Values;-

    A34 = Heritage Rly Assn Business Development Committee
    A35 = North London Rly Historical Society
    C34 = 23/09/2009 (formatted as WEEKDAY DD MMM YYYY)
    D34 = 23/09/2009 13:30 (formatted as HH:MM)

    In Cell C34

    Format condition 1:-

    =A34<>A35 , Format Bottom Border

    Format condition 2:-

    =AND(WEEKDAY(C34)>1,WEEKDAY(C34)<7,HOUR(D34)<18,A34<>A35), Format Bottom Border and Yellow pattern

    Format condition 3:-

    =AND(WEEKDAY(C34)>1,WEEKDAY(C34)<7,HOUR(D34)<18), Format Yellow pattern

    In cell c34 Format condition 1 activates NOT condition 2.

    In another cell, C13, condition 3 correctly operates; in this row A13 = A14. Condition 1 works i.e. the cells A1 and A2 are the same only cell A2 has the bottom border and if Cell A2 and A3 are different there is a bottom border in both cells.

    There must be something wrong with my formula in condition 2 but I can't see what; condition 2 is just condition 1 amd 3 amalgamated.

    The condition 2 should read:

    If the date is not a Saturday or Sunday in cell C34 and the time is before 18:00 hours in Cell D34 and the name in the "a" cell i.e. A34 does not equal the name in the "a" cell below this one i.e. A35 put in a bottom border and colour the cell yellow.

    Can anyone please advise?
    Last edited by athegn; 07-29-2009 at 04:20 AM.

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Bottom border and Yellow pattern in Condition formatting

    conditions work in order given so if
    =A34<>A35
    condition one is met so it will not look at condition 2
    try swapping 1 and 2 around
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    07-11-2009
    Location
    London
    MS-Off Ver
    Excel 2000
    Posts
    12

    Re: [SOLVED]Bottom border and Yellow pattern in Condition formatting

    Thank you; now working as required.

    Please note I have now raised an additional question:-

    http://www.excelforum.com/excel-gene...ml#post2134752

+ 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