Conditional formatting.

  • Thread starter Thread starter owiek
  • Start date Start date
O

owiek

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 Format>Conditional 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(C1>0,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
 
Back
Top