It's Gonna Be A Hot Summer

re: It's Gonna Be A Hot Summer

Jonathan Snook — Fri, 10 Feb 2006 22:48:20 GMT

I've used conditional formatting in previous versions of Excel. For example, I use it to keep track of my finances. Any bill due in the next couple weeks will be highlighted in red as a reminder to pay it (or be aware that it's coming out automatically).

(big fan of the blog, btw... looking forward to O12)

re: It's Gonna Be A Hot Summer

Steve Trefethen — Sat, 11 Feb 2006 01:30:28 GMT

"But in reality, the purpose of any UI framework is to support the programs using it--and ultimately to enable them to provide awesome user experiences."

Great statement and is exactly why I hope MS decides to make all this hard work available to all Windows developers.

Again, thanks for blogging Jensen I always look forward to your posts.

Have a great weekend.

-Steve

re: It's Gonna Be A Hot Summer

Stuart Swindells — Sat, 11 Feb 2006 02:20:46 GMT

Yeah, conditional formatting existed before, but it wasn't /as/ easy to create effects like in the screenshot.
Fan of the blog here too, good informative look into where O12's going. :)

re: It's Gonna Be A Hot Summer

Suzanne S. Barnhill — Sat, 11 Feb 2006 21:09:00 GMT

Conditional formatting is available in Excel 2003 and previous versions, though I suspect the implementation is much slicker in Excel 12. I don't know whether there's a limit to the number of conditions you can have; the most I've needed is two: in the attendance sheet I maintain for my Rotary club, I mark those with 100% attendance in yellow and those with less than the required 60% in blue.

For those who don't know how to get started, see Excel's Help topic "Add, change, or remove conditional formats."

Need I add I'm also a fan? <g>

re: It's Gonna Be A Hot Summer

KirkMorrant — Mon, 13 Feb 2006 06:07:43 GMT

I remember the days when conditional formatting involved typing lots of codes into the Format Cells dialog box. And all THAT did was change the text colour! I'm gonna be like a kid in a candy store with O12! Oh boy, oh boy, oh boy!

re: It's Gonna Be A Hot Summer

LesC — Mon, 13 Feb 2006 06:32:09 GMT

I'm going to be a spoilsport, but I think that table is ugly as sin and really hurts the eyes. It also has the (undesirable?) side-effect of making it very difficult to read the actual numbers.

I hope against hope this is not a built-in effect.

re: It's Gonna Be A Hot Summer

jensenh — Mon, 13 Feb 2006 06:47:39 GMT

Les,

You can, of course, choose not to apply this effect. But I think it does help to visualize the relative temperature patterns of the different cities (which is many cases is more important than scrutizing every number.)

I do agree that there are many cases in which this kind of formatting wouldn't make sense.

re: It's Gonna Be A Hot Summer

Luc — Wed, 15 Feb 2006 13:06:54 GMT

Very cool feature! One cool idea might be to have a custom iconset with thermometers in the cells. To go a step further, allow the colors be be applied to the 'mercury area' of the thermometer. Yeah... I know, I'm being that guy. :)

I'm a big fan of your blog too, Jensen. Keep 'em coming!

Jensen Harris An Office User Interface Blog It s Gonna Be A Hot Summer | Quick Diets

Tue, 09 Jun 2009 14:41:37 GMT

PingBack from http://quickdietsite.info/story.php?id=2593