Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et
Ex. A2 is a bunch of numbers that have been conditionally formatted to show
up as green if between 30 and 34, yellow if between 35 and 45 and red if 46 and over. However, I need B2 to display the word 'green', 'yellow' or 'red' depending on the number range in A2. Intuitively? Easy. In reality? I'm completely stumped :-P Help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
Change number format from text to number? | New Users to Excel | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
How do I look up a number within a string of text | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions |