How to use conditional formatting with logical operators present in the excel sheet

Hello,

I am not able to use conditional formatting when the condition cell contains ">=" operators.

The sheet has a target column (col A) which has value >=10%
If achievement column (col B) has values:-
<10% it should highlight in Red (e.g.: -10%, 0%, 5%)
if >=10% it should highlight in Green (e.g.: 10%, 20%)

Conditional formatting works on the achievement column when I input 10% in the target column but does not work when i input target as >=10%

I have attached sample excel sheet for your reference, please see Row 6.

Thanks

Hi benishiryo,

Thank you for the quick reply.

I applied the formula as you suggested and it worked, the values >=10% were highlighted in Green.
Is there a way to do the same where <10% is highlighted in Red?

Thanks