VBA for conditional formatting in 2003

I need some VBA assistance with conditional formatting please in 2003.

In a range of cells G4:DX200

I am making entries 1 to 11, where required. So any cell within the range would have one number i.e. 1 or 2 or 3 etc to 11. (Lets make it 15 to allow for growth)

I want to be able to able to have the cells fill with different colours according to the number input. I’m not fussy about what colours they are as long as they are all distinguishable from each other.

The characters need to remain black and readable.

I’ve seen an example somewhere before that I was able to adapt but cannot find anything suitable now.

Thanks in anticipation.

Hi Russell

Take a look here.

http://www.excelforum.com/excel-prog...ther-cell.html

Hi Fotis,

As you can no doubt tell, I'm new to VBA. Can't even view it in the workbook you sent. New learning curve ahead I think!

Regards

Russell

...You are New to VBA, but i have no idea about it!!

I had seen that post and tried to help you.

Thanks for trying anyway. I'll post it if I get it from elsewhere.

Regards

Russell

Found it.

Please Login or Register  to view this content.

This gives you 15 different colours when cells containing numbers 1 to 15 are detected.