Change cell color dependand on cell value

Hi everyone.

I am pretty new at Excel programming, so please bear with me on this easy question...

I have a cell where the user inputs a value between 1 and 5.
If its "1", make cell background light red and text color dark red
If its "2", make cell background light yellow and text color dark yellow
If its "3", make cell background light green and text color dark green
etc..

How do I do this?

Use Conditional Formatting
Select the cell you are interested in. On menu click Format>Conditional Formatting and then select the options you want. It will guide you through with easy steps.

A V Veerkar

Thanks VBA Noob - that was just what I needed.

It works great and looks really cool too :-)

Perhaps you should change name to VBA L33T ?