Changing colours of a cell

February 27, 2011 at 17:15:34
Specs: Windows 7
Hi I was wondering how can you change the colour of a cell when there are over 5,000 different cells to do? I have 4 colours to refer to and my Excel skills are struggling. I need the cell to refer to a different cell and need to display a number in the original cell. Does this make sense?

See More: Changing colours of a cell

Report •

#1
February 27, 2011 at 17:27:03
Sory I have an example - if in A1 I have 1000 and I'm trying to match this numer from K1, L1,S1 or Z1 and each range has a different colour just want a quicker way rather than entering it in for each cell 5,000 times.

Report •

#2
February 27, 2011 at 18:54:06
You posted in the wrong forum. Unless the moderator is willing to move it for you, you would be best to repost it to the Office Software forum where there are those who can answer your question.

You have to be a little bit crazy to keep you from going insane.


Report •
Related Solutions


Ask Question