how do i set a cell to change color when setting targets

[dave6453]

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 worksheet

 

[Kevin Spencer]

Hi Dave,

You need to post this to an Excel newsgroup. Try microsoft.public.excel.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
You can lead a fish to a bicycle,
but it takes a very long time,
and the bicycle has to *want* to change.