big conditional formating problem

[Casey]

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

[Juan Pablo González]

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 ?

[Casey]

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

[Juan Pablo González]

Then, Instead of A1 as I suggested, try with

This formula

=resultsheet!O14>1

and

=resultsheet!O14<=1

[Casey]

Yes thank you I think that may work.