In the past I commented about the fact that Revit MEP has conditional formatting while Revit Architecture and Structure do not. That is still technically true but... fast forward to now...
David Baldacchino and I were exchanging some emails about work arounds and I was lamenting about the conditional formatting again. He remembered that he discovered a real good trick!
When you are creating/editing a schedule and select a value that can be formatted, like Area or a Number value for example, are you listening? Press the ALT & N keys at the same time and this dialog appears. Yes in Revit Architecture and Structure!
Conditional Formatting in schedules regardless of the version of Revit still does not show up when a schedule is added to a sheet however. This means the tool is useful primarily for internal checking or as an analysis tool but fails to deliver for presenting the information to others. Always leave us wanting more do they?
P.S. This works in Revit 2009 and 2010. Keep in mind that undocumented finds like these may mean that the factory didn't know it was possible and therefore it is technically unsupported. Use it at your own peril?