Thread
:
Need Help Generating a Specific Formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
external usenet poster
Posts: 3,268
Need Help Generating a Specific Formula
Use formatconditional formatting, assume J4 is the cell you want to format
and H3 the budgeted value, select J4
for the first condition use
formula is
=J4/$H$3*100<90
click the format button and select green pattern, click OK then click add
now use
=AND(J4/$H$3*100=90,J4/$H$3*100<=100)
repeat and select orange/yellow pattern
finally for the third use
=J4/$H$3*100100
repeat and select red then close by clicking OK twice
--
Regards,
Peo Sjoblom
"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.
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom