Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Conditional Formatting

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Using the following formula:
    =LEFT($L1,2)="O-"
    highlights the entire row if it meets the criteria, if I only want to highlight between columns A to L then how would the formula look?

    Thank you all for your patience, I know I still have a great deal to learn but I feel so much more confident about Excel since finding this wonderful site.
    Thanks again

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I haven't tested this, but if you just select columns A to L and enter the formula you already have, then that should work OK. (n.b. if you have conditionally formatted the entire sheet, you will need to delete the formatting first then do the above).

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

    Default

    Just select the column indicators A to L, then apply cond format with the formula you have.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Of course it does.
    Sorry to waste your time Mudface, I must start thinking more logically!

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

    Default

    On 2002-05-01 02:36, MattB wrote:
    Of course it does.
    Sorry to waste your time Mudface, I must start thinking more logically!
    How about my time ?

    Relax: just kidding.

  6. #6
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There is a way that you can program the whole row...

    Enter the conditional formating as follows

    Formula is =AND(LEFT($L1,2)="O-",COLUMN()<13)

    This can be entered throughout the whole line.
    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

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
  •