How to color a column value based on % of completion of another column % value in excel?
Example :
My requirement is that adding a color based on work done % value. Suppose billing value >=50% of workdone cell value then add a green color to billing cell else red value.
I tried couple of way to add a new rule from conditional formatting but no luck.
Can anybody help me to solve this?
Note: Both cells(work done and billing) value varies based on completion of task.