On the menu barformatconditional formatformula is

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gene Cocchi" <Gene wrote in message
...
I am trying to create a "Traffic Light" formula and an experiencing
difficulty. What I am trying to accomplish is if I have a budget # of ,
say
$3, If the actual cost is less than 90% then Iwant the cell to show green
in
color. If the number approaches 90%-100% of the budget # than I want the
cell to show as yellow. And, If the actual nuber exceeds the budget #
($3),
then I want the cell to show up red in color. Has anyone had experience
with
this type of situation and if so could you please lend me some pointers?
Thanks in advance.