Lazywebs: Conditional formatting in Excel?

[the_macnab]

O Internets:

Assume that I have a spreadsheet in Excel whose cells take the values of -1, 0 or 1. I would really like to do some conditional formatting: that is, to tell Excel: "If the cell equals 1, color it red." Does anyone know if this is possible? It certainly should be.

Comments

[burgundy]

My understanding is that it's not set up to do this, but I don't hold myself out as any kind of authority. If someone comes along to prove me wrong, I will clap my hands with glee.

ETA: Ok, so, I don't know what I'm talking about, and I clap my hands with glee. I don't know how I'll use this at work just yet, but by god I'll use it on something.

[zinereem]

http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

[the_macnab]

O-KAY. I will try this tomorrow and report back.

[lexicat]

As has been mentioned, yes. And it's pretty powerful. I've put in some 100 character macros to reference appropriate cells and compare them to other cells and blah blah. Of course, you have to get intimate with the function language. Bleck.

My main regret is that it only supports up to 3 conditions on macs. And the shit they have in Excel 2009 now is pretty amazing. Select range -> color everything by mean+-standard deviation of that range. Can't be done at all in 2008. :(