Can you Color Code in Excel?

Reply #7

Rakster — Tue, 31 Jul 2007 00:34:49 GMT

Thanks for the info guys... muchly appreciated

Reply #6

tben — Sun, 29 Jul 2007 14:43:13 GMT

Hi Rakster,

I think you can do what you want using conditional formatting under the format drop down menu. You specify the cellls it applies to and can select the condition, e.g. equal to, greater than, etc. Then you put in the vaule the cell would be equal to or whatever. Then you go to font and choose a color. It then will do it for you automatically.

Good Luck,

Terry

Reply #5

WIN D — Thu, 26 Jul 2007 15:03:38 GMT

Rakster.... are you going to try to color code each of the 6 ways....and the 3 way doubles? If thats it... Great idea.

I was just thinking of using numbers .... 100 (1.) 001 (2.) 010 (3.) .....etc.

Wanted to see the 6 ways more than doubles..... because it's an even number of WAYS.... then I could watch for many odds in a row....or Highs....etc. You know....

Color would give us a great visual cue ..... many green or Red ...etc. in a row.... or LACK there of.

Having... [ More ]

Reply #4

time*treat — Thu, 26 Jul 2007 02:54:19 GMT

Heh, I always forget the non-macro way to do these things. I haven't used that feature in ages.

Reply #3

hypersoniq — Thu, 26 Jul 2007 02:30:31 GMT

You want Conditional Formatting

you can't find it in the right-click menu, it's up on the format menu. It allows you to specify either a new background color for the cell, a new font color or both if up to 3 different conditions are met.

use Excel help, it explains the process well enough to get you going.

Reply #2

Rakster — Wed, 25 Jul 2007 04:16:58 GMT

I don't think you understand my question. I only want the number to be colored once its called not before.

Reply #1

love2play — Wed, 25 Jul 2007 04:01:41 GMT

if you change the color at the format tab

Can you Color Code in Excel?

Rakster — Tue, 24 Jul 2007 21:57:29 GMT

What I mean is, is it possible to have your numbers show up in a certain color when applied.

This is what I am trying to do...

100100010001#####010

In my spreadsheet I have a chart.. the number (100) is shown with 3 different ways it can hit 100, 010, 001 ... On the right side you see #### and 010

Is it possible to get that 010 to turn say Green when the 100 is entered on the left without the ##### turning green too. But once that particular # is entered into the