Conditional Formatting for PO & CM

[malekari]

Hi,

I appreciate if anybody help to put conditional formatting for the below details;
I have the below table, where the result is PO Bal & CM Balance. Now, I want to put conditional formatting to these column;
if the value exceeds 80% of the PO & CM value, then Yellow
if the value exceeds 90% of the PO & CM value, then Red

15k-(10+2) 20k-(10+2)

CM PO Billed Billable PO Balance CM Balance 20000.00 15000.00 10000.00 2000.00 3000.00 8000.00 <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>
Regards, Ivan

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>