software

i am working with targets on my worksheet. how can i set a cell to change its
colour according to the data entered. I.E. i set a target of 9% and i want
the cell to change colour to green when 9% or less is entered, if above 9% i
want it to turn red, if within 10% of the target figure i want the cell to
turn yellow. is this possible?

i am using an XP exel worksheetassuming the cells are in A, and the target amount is in M1, then select
them all

Menu Formatgt;Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =A1gt;M1*.91
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour - greenb
OK
OK

Second condition

Click Add
Change Condition 2 to Formula Is
Add a formula of =A1gt;M1*.09
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour - yellow
OK
OK

Third condition

Click Add
Change Condition 2 to Formula Is
Add a formula of =A1lt;=M1*.09
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour - red
OK
OK

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;dave6453quot; gt; wrote in message
...
gt; i am working with targets on my worksheet. how can i set a cell to change
its
gt; colour according to the data entered. I.E. i set a target of 9% and i want
gt; the cell to change colour to green when 9% or less is entered, if above 9%
i
gt; want it to turn red, if within 10% of the target figure i want the cell to
gt; turn yellow. is this possible?
gt;
gt; i am using an XP exel worksheet
gt;