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

Thread: Conditional Formatting based on various conditions

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

    Default

    Help!!!!

    I am trying to format a table of info. I have 15 values I have placed into another sheet. I have a column of Data (Column D), if any values in Column D equal one of the values on the other sheet I would like to have the cell grayed. I am stuck as it seems I can only compare conditional formatting for one value.

    Thanks.

    Gary

  2. #2
    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

    See http://www.mrexcel.com/board/viewtop...917&forum=2&15 and note that can't have your comparison values on another worksheet.

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-22 08:42, gflynn wrote:
    Help!!!!

    I am trying to format a table of info. I have 15 values I have placed into another sheet. I have a column of Data (Column D), if any values in Column D equal one of the values on the other sheet I would like to have the cell grayed. I am stuck as it seems I can only compare conditional formatting for one value.

    Thanks.

    Gary
    Select all the cells where you entered 15 values, go to the Name Box on the Formula Bar, type ValSet, and hit enter.

    Lets say that your data start at row 1 (D1) in D.

    Select column D.
    Activate Format|Conditional Formatting.
    Select Formula Is for Condition 1.
    Enter as formula:

    =COUNTIF(ValSet,$D1)>0

    Activate Format.

    Select the color of interest on the Patterns tab.
    Click OK, OK.


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

    Default

    Thanks, works like a charm

    you folks are the greatest.

    Gary

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
  •