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 !!!)
Bookmarks