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
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