Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Format (Excel 2000)

    Is there a way to contitionally format the cells in YELLOW that hold the words "LWCHRG" no matter how it is written? Am sending an example file with the array formula in conditional formatting that I thought would work, but it's not. Thank you for any help. That formula goes like this:

    =IF($A$2:$A$7="(1) LWCHRG",IF($A$2:$A$7="LWCHRG",IF($A$2:$A$7="LWCHRG (2)",IF($A$2:$A$7="LWCHRG 1234",1,0),0),0),0) then press CTRL SHIFT and ENTER and ask for Yellow Shading in the cell.

    NMP
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Format (Excel 2000)

    In the first place, if you want to use a formula in conditional formatting, you should select "Formula is" in the first dropdown list instead of "Value is".
    In the second place, you must refer to the active cell in the formula, not to the entire selected range.
    In the third place, I showed you yesterday how to use ISERORR and FIND to determine if a string is part of a cell value. You can use them here too:
    - Select A1:A7.
    - Select Format | Conditional Formatting...
    - Select 'Formula is' in the first dropdown list.
    - Enter the following formula:
    <code>=NOT(ISERROR(FIND("LWCHRG",A1)))</code>
    - Set the desired format.
    - Click OK.
    Excel will automatically adjust the formula for the other cells in the selection.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Format (Excel 2000)

    In the first place, thank you.
    In the second place, I had it on Formula is on several attempts
    In the third place I did use your find formula from yesterday, evidently I was writing it incorrectly because I had no luck...

    Thank you again Hans and apologize for getting stumped where I should have been ok...it's truly one of those weeks...Christmas and all, and major job cutbacks here which are beginning to frazzle my sense of thought process.


    NMP
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •