Help Excell stuff again.....I am so thick[blush]

[Katymac]

OK I have numbers 1-75; each one has a number 1-16 next to it

the numbers 1-16 respond to 16 statements

I want the right statement in the box next to my origional 75 numbers......any idea how?

tia
KMc

To be honest, I don't think you can do what you want automatically without writing a macro, which means a bit of basic programming. I think conditional formatting only lets you choose three conditions, so in your case you could have up to three colours but not sixteen different colours. You can of course set the colours manually, but that's not much help..... sorry.

Yes please

Ooo I used to do macro's (in a previous life before I became a childminder)

What he said... I suppose you could have different combinations of shading/patterns/colours, but you wouldn't be able to read what was in the table then...

If I just did =the cell I want the colour comes up

So - where do I go from here?

would CHOOSE help?

Thanks LittleLapin - I have sent the bugger

(I think I take childminding too seriously)

It's random (well it isn't to in order to get it right it can be - does that make sense?)

I want it so when I type in any number (1-16) the relevant phrase comes up

So I can save it as a standard form & complete as necessary

& if you make the number I type in disappear when I print it out - I would love you forever

yep - just the four (but I couldn't explain that easily before )

Not sure I understand that

I will have a look and worship you from afar (but only if I understand it)

It looks impressive tho'

Absolutly fabulous

OFSTED will be so impressed (well prob not....but anyway)

Thank you so much

much appreciated

Off to bed now

That's enough unpaid overtime for tonight

OK - I need more help

The look up table now has 3 columns - can you make that happen?