Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: formatting based on a condition

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

    Default

    Duh - I need to read before I reply...
    Thanks...

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-22 08:09, paulrus wrote:
    If I can't use an array, how do I format based on a list of states? I don't quite understand how what you wrote would work if Excel has no idea that I only want those specific states to be colored differently.
    1. List your state abbreviations in column A of a new worksheet (e.g., Sheet2).
    2. Select the entire row 6
    3. Choose the Format | Conditional Formatting... menu command
    4. Setup a "Formula Is" condition using =COUNTIF(Sheet2!A:A,$E6) and applying a green cell pattern.

    [ This Message was edited by: Mark W. on 2002-04-22 08:15 ]

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

    Default

    You can't use reference to other sheets using conditional formatting.... or at least that's what Excel is telling me...


  4. #14
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-22 08:23, paulrus wrote:
    You can't use reference to other sheets using conditional formatting.... or at least that's what Excel is telling me...
    Ahh, that's probably true. I was trying to simplify my instructions. Just find some unused space on your worksheet, enter your state abbreviations there, and use that cell reference as the 1st argument to the COUNTIF function.

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

    Default

    I moved them to A70-84 and changed it to read:

    =COUNTIF($A$70:$A$84,$E6)

    However any row I apply this to changes color regardless of whether or not it matches A70-84.

  6. #16
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-22 08:39, paulrus wrote:
    I moved them to A70-84 and changed it to read:

    =COUNTIF($A$70:$A$84,$E6)

    However any row I apply this to changes color regardless of whether or not it matches A70-84.
    I can't replicate your problem. Be sure that you're following these steps...

    1. List your state abbreviations in A70:A84
    2. Select the entire row 6
    3. Choose the Format | Conditional Formatting... menu command
    4. Setup a "Formula Is" condition using =COUNTIF($A$70:$A$84,$E6) and applying a green cell pattern.

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

    Default

    Interesting - I found a minor bug in Excel I think.

    Basically I was trying to select multiple rows to accomplish the task. However, Excel formats the first row selected to whatever color you choose regardless of whether or not it matches the list.

    I just selected the row above where my data starts and now the page formats correctly.

    Thanks for the help!

    Paul

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
  •