Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Generating a Specific Formula
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to add specific #'s across the top | New Users to Excel | |||
SUM formula generating formula instead of result. | Excel Worksheet Functions | |||
My cell formula is generating an unwanted e-mail message. | Excel Worksheet Functions | |||
Need help with generating a formula PLSE. | Excel Discussion (Misc queries) | |||
Formula generating a column of data? | Excel Worksheet Functions |