I saw this article in Lifehacker this morning.
All about how conditional formatting in Excel is so useful. Well, yes, it is, but (as I said while bristling slightly, in my comment on the lifehacker site ;> ) you can do the same things in OpenOffice.org Calc spreadsheets.
Here's how you use conditional formatting.
First, you have to make styles. There's no way around this but it's very simple.
1. Choose Format > Styles and Formatting.
2. Be sure that Cell Styles are displayed in the Styles and Formatting window.
3. Right-click in a blank spot and choose New.
6. Click OK.
Next, just set up the conditions. Let's say that you want to have a total show up with the GreenBold style you just created, if it's 500,000 or more, and you want it to show up as RedItalic style if it's 200,000 or less. Click the following image to see it bigger.