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

Thread: Condtional formatting

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

    Default

    I am trying to find a way to conditionally format an entire row in a spreadsheet to a specific color highlight. The data in each column is different. Is there a way to set up a "code" in a column, such as "1", "2", etec that would condtionally format the entire row. Or is there another way to do this?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Conditional Formatting will work for up to three conditions. If you need more, it will require code. Please post an example of your data.

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

    Default

    Can you tell me how to post a file?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can't post a file, per se, to this board but if you can tell us what colour you require row 5 or row 7 and on what basis it is coloured that particular colour, we can probably help out a bit more

    ie :

    if my amount in column G is ever = 100 then the whole row should be a blue background

    or

    if the row number is odd, I want a grey background whilst if the row number is even then I want it to stay as it is

    that sort of thing


    :: Pharma Z - Family drugstore ::

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

    Default

    do you want a formul in conditional formatting or VBA..

    you will need to map out you data trigger and requiremenst


    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
  •