I'm trying to achieve a simple conditional formatting where there are two conditions need to be achieved. The first condition is to find out which of the value in Column B is lesser or equal to 0.0500. I'm able to achieve this using the true false method with the formula below.
Once the condition has been met, it will then need to find out which of these is the MAX (highest value) in Column C. For this, I'm facing some difficulties to achieve the second criteria conditional formatting.
I have attached the reference as per below. Thanks!
Don’t have an account yet? Register yourself now and be a part of our community!