I'm trying to conditionally format one cell depending on data entered into
another.
Ex;
a b c
1
2

If C1 = 100% A1 should be formatted Green
If C1 = Between 0% and 100% A1 should be formatted Yellow
If C1 - 0% A1 should be formatted Red

Is there away to do this