Conditional formatting wizard question
Conditional formatting wizard question
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Conditional formatting wizard question

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

    Default

     
    I want the text in cell b2 to be "fail" if its value is greater than the value in cell a1 and "pass" if it is less. Can I use the conditional formatting wizard for this?
    TIA,
    W.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-02-25 11:44, wking1976 wrote:
    I want the text in cell b2 to be "fail" if its value is greater than the value in cell a1 and "pass" if it is less. Can I use the conditional formatting wizard for this?
    TIA,
    W.
    Cond Format cannot compute a value like "Fail" or "Pass". However, you can highlight a cell or range of interest with color and other formatting features.

    Have a look at conditional formatting under Help of Excel.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Edit- Hehe, every answer I give seems to be about a minute after someone else, must be getting old

    Not to generate text, no, and the way you have it set up you will end up with a circular reference.

    The best you can do with conditional formatting is to change the colour of the cell or font to reflect the 'pass' or 'fail'. To do this, click in B2, click on Format-Conditional Formatting and change Cell Value Is to Formula Is. Enter

    =$A$1 > $B$2

    and select your format (eg Red font). Click on Add>> and enter

    =$A$1 < $B$2

    and choose another font colour (eg blue). HTH.

    [ This Message was edited by: Mudface on 2002-02-25 11:55 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    It's probably best to have some other cell (like B3) show the pass or fail. But if you
    really want B2 to be Pass or Fail, then you
    can put the following in the Worksheet_Calculate
    code for the worksheet:

    Private Sub Worksheet_Calculate()
    If [F8].Value <= [E7].Value Then
    [F8].NumberFormat = """Pass"""
    Else
    [F8].NumberFormat = """Fail"""
    End If
    End Sub
    "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

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
  •  

 

 
DMCA.com