Hi,

Am Wed, 3 Oct 2012 08:53:34 +0000 schrieb the-chauffeur:

I have a range of cells (B3,B5,B7,B9 and B11) that start out blank and
are validated so users can only select one of 4 responses:

<BLANK
RED
AMBER
GREEN

I want to put some kind of function in cell A2 so that if any one of the
B range cells contains text, A2 shows Y - and if not, it's blank.

try in A2:
=IF(COUNTA(B3,B5,B7,B9,B11)0,"Y","")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2