Conditional Color

Robert K

Hi all!

How do I create a formula if the result is between 1.00-1.10 it will turn green and if all others - it will turn red?

It will have to be added to this current formula because the cell uses it to calculate the average.

=([1st Patient H/L]@row + [2nd Patient H/L]@row + [3rd Patient H/L]@row) / 3

Thank you!!

Scott Peters

Hi @Robert K - I would recommend a hidden helper column called "COLOR" like this:

=IF(AND([Total Mean (Acceptable = 1.00-1.10)]@row > 0.99, [Total Mean (Acceptable = 1.00-1.10)]@row < 1.1), "Green", "Red")

Then set up your conditional formatting like this:

Hope that helps

Robert K

Awesome, thanks Scott!

Scott Peters

Hi @Robert K - I would recommend a hidden helper column called "COLOR" like this:

=IF(AND([Total Mean (Acceptable = 1.00-1.10)]@row > 0.99, [Total Mean (Acceptable = 1.00-1.10)]@row < 1.1), "Green", "Red")

Then set up your conditional formatting like this:

Hope that helps

Robert K

Awesome, thanks Scott!