Change Cell Colours according to number input

[PeteB]

How can I setup excel to complete a cell colour according to a number I input elsewhere on the sheet, ie: if say, I input number 1 in cell A1 and this would automatically change the colour of cell B1 to red .... input 2 in A1 and B1 changes to blue, etc

Maybe not possible but can anyone help? Perhaps this is a VBA issue in which case I would need an "idiot guide" to help me.

Thanks

 

[Andy Brown]

In XL97 and later, you can do this with conditional formatting (Format
menu), eg:

Cell value is -- equal to -- 1. Click the Format button. On the Font tab,
choose a colour. Click OK, then OK again or Add to add another format. The
limit is (3 formats + original ie: black =) 4. Any more & you'd need code
(event procedure).

Rgds,
Andy

 

[PeteB]

Hi,
Thanks for that but I'm a bit lost when it comes to actually doing this - I
need to use 7 different colours so, as you've advised, I'll need to place
the code in a sheet module. How do I do this and how do I actually get this
to work for each cell on the spreadsheet?
I'm using Excel 2000 and the help files don't really help. When it comes to
code and stuff I really need an 'idiot guide'.
Thanks.