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

Select cell A1
Goto the menu FormatConditional Formatting

Condition 1
Formula Is: =C1=1
Click the Format button
Patterns tab, select a shade of GREEN
OK

Click the Add button

Condition 2
Formula Is: =AND(C10,C1<1)
Click the Format button
Patterns tab, select a shade of YELLOW
OK

Click the Add button

Condition 3
Formula Is: =(C1<"")*(C1=0)
Click the Format button
Patterns tab, select a shade of RED
OK out


--
Biff
Microsoft Excel MVP


"owiek" wrote in message
...
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