Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: big conditional formating problem

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

    Default

    Hello,
    I have a problem with a workbook that has several sheets.. What Im trying to do is I have an intial sheet with laboratory results in, then I have another sheet which organizes the data in a differnt array, but I use an If function and if the result is less than 1 then 1/(result) is used, otherwise simply (result) is used. Now the problem is can I make a conditional format as to if the cell is (result) or 1/(result) and make the first red and the second green. The values will be similar, so I cant discern using numerical values. I dont know if VB is necessary, but I would be happy to go that route also.
    Any help you can give would be appreciated or any further clarification I can give please let me know
    Casey

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think this CAN be achieved using Conditional Formatting...

    If Result is in A1 then try this for the first condition.

    Value Is
    Less Than
    1

    And click on the Pattern button, and select RED as font color, or background color.

    Add another condition but now select
    Value Is
    Greater or equal than
    1

    And select GREEN now.

    Is this what you're looking for ?

    Regards,

    Juan Pablo González
    http://www.juanpg.com

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

    Default

    Unfortunatly It wouldnt work, the cells will have roughly equivalent values, the determining factor will have come from the formula [=IF(resultsheet!O14>1,resultsheet!O14,1/(resultsheet!O14)). Each cell uses this formula and the resultsheet is another sheet in the workbook. And after the formula has been done, the values in the cells are relatively the same. I just want to know if there is a way to format the cells depending on if the above formula is found true or false.
    Thanks Casey

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Then, Instead of A1 as I suggested, try with

    This formula

    =resultsheet!O14>1

    and

    =resultsheet!O14<=1
    Regards,

    Juan Pablo González
    http://www.juanpg.com

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

    Default

    Yes thank you I think that may work.

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
  •