Darned if I'm having the same problems with mismatched colours and the alert
text as mentioned above.

A2:A1000 is derived from another forumla: =DATEDIF(A3,$C$1, "d") [which ever
date I submit as the date of the report - Date Received of Document]

Could this be screwing up the forumlas? Or am I just cursed by the Excel
gods? <-- entirely possible as our tech guys are convinced I can
single-handedly bring down the entire internet with one press of a button :-)

"David Biddulph" wrote:

You had a number of conditions for which your required result was undefined
in your question, but what about
=IF(A2=46,"Red",IF(A2=35,"Yellow",IF(A2=30,"Gre en",""))) ?
--
David Biddulph

"MS Questionnairess" wrote in
message ...
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?