Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: conditional formatting question

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I use the conditional formatting with two conditions:

    1. Condition 1: enter the formula =(isblank(A1)) and select patterns, no color. The cell will remain non-shaded until a value is entered.

    2. Condition 2: enter your other formula with desired color, etc.

  2. #12
    Board Regular
    Join Date
    Apr 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin,

    =AND(ISNUMBER(A1),A1=MIN($A1:$F1))works too. Both formulas are identical with the exception of ($A1:$F1) versus (1:1). Please comment on the differing logic as I'm eager to learn.

    Thanks,
    Jim

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

    Default

    =AND(ISNUMBER(A1),A1=MIN($A1:$F1))works too. Both formulas are identical with the exception of ($A1:$F1) versus (1:1). Please comment on the differing logic

    $A1:$F1 will restrict cond format to columns A and F in all rows to which the cond format is applied, while 1:1 would apply to all columns in all rows to which the cond format is applied. If column F is the limit, the former should be used.

    Aladin

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
  •