Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Logic help. Conditional Formatting (Excel 2003)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30>
    I want to keep a sheet that shows what my blood test results are. I don
    Bob Wall

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Logic help. Conditional Formatting (Excel 2003)

    <P ID="edit" class=small>(Edited by sdckapr on 22-Feb-05 16:11. Added comment)</P>Set the first condition to "equal to" ="" [Include the equal sign]
    [format] as desired
    The second to "Less than" 135
    [format] as desired
    The third to "greater than" 148
    [format] as desired

    The "blank" must be the first condition. It stops after finding the first true one. (It is also <135)

    Steve

  3. #3
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logic help. Conditional Formatting (Excel 200

    Select the column containing your Sodium levels and:

    1st condition - between 135 and 148 - No Fill
    2nd condition - greater than 0 - Yellow

    Is that what you want?
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  4. #4
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Re: Logic help. Conditional Formatting (Excel 2003)

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    I did do the blank first. I've never come across the ="" before. I'll look it up later. When using conditional formats, the = sign means whatever's in this cell that equals "" , which is a blank cell, is the criterion.

    Thank you for your assistance. <img src=/S/bow.gif border=0 alt=bow width=15 height=15>
    Bob Wall

  5. #5
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington
    Posts
    251
    Thanks
    29
    Thanked 2 Times in 2 Posts

    Re: Logic help. Conditional Formatting (Excel 200

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    This is another excellent suggestion. The only question I have is,
    Bob Wall

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Logic help. Conditional Formatting (Excel 200

    No, a blank cell is NOT greater than zero, it is equal to zero. That's why the greater than test works, it only formats the cell if it contains a value greater than zero.
    Legare Coleman

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Logic help. Conditional Formatting (Excel 200

    In bandido's suggestion, an actual zero would not be indicated as "low" with color.

    Steve

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Logic help. Conditional Formatting (Excel 200

    Hey tall and good looking,

    if you are going to be tracking your blood test results for a long time (ie, not stopping because you decide you had enough of the exercise), you may want to take into account that the acceptable levels of a particular test can change as we age. I don't know about your particular tests (sodium) but I've read articles and have personal experience in other blood tests. Also I'm not sure why you seem concerned only with tests that are done infrequently - why not track all of them?

    So you have to be careful here. If you only set up one set of limits, you'll have to change your conditional format tests at some time to take new limits into account as you get older.

    But getting back to the problem at hand: say your blood test result is in A1, then the following will give you a result that can be the basis of choosing some shading or other effect if the value in A1 is <135 but >0 (so blank excluded) or >155. Use the drop down that normally says "Cell Value Is" and change to "formula is". Enter the formula as
    =OR(AND(A1>0,A1<135),A1>155)
    and then choose your shading as yellow or whatever you want to alert you. The AND test is for the lower part of the range (below the lower bound of acceptability) to take into account the blank situation.

    If you want different "alerts" depending on whether you're over or under, then you can break the above apart into 2 tests. You can also try the "Cell Value Is" approach as already suggested by others.

    Fred

Posting Permissions

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