I have a spreadsheet where cell C& requires the user to enter either "Y"
or "N". Depending which they enter I need to recolour cells B7:B12.

I have completely run out of ideas for how to do this - Excel bible,
web searches etc. have not solved the problem.

Can someone please please put me out of my misery - I know it can be
done and I'm sure its simple (when you know how)?

Many thanks

Tony (now you know why I log in backwards ... ynoT !!!)


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=389006