Styles for conditional formatting
The applicability of styles would be greatly enhanced if they could be included in conditional formatting.
Example:if the value in this cell is zero or negative than it would automatically receive the Bad style, otherwise the Good style. (It is hard to see use for these two styles without them being applied by conditional formatting)
This would be very helpful - a link between Conditional Formatting and Styles please!
Kevin Osborn commented
A great addition to all the other complaints/suggestions out there regarding conditional formatting. Conditional formatting needs an overhaul and this should be included. It's really convoluted to try and create this manually by creating 20 different formats and then having to replicate them all by hand to different ranges.
J Beck commented
I regularly use a conditional formatting for input fields: Fields that need user input are filled in yellow. Once data has been provided, the yellow fill disappears so you can quickly see if something's missing and the completed document looks better without the garish yellow input fields. Doing this is a multi-step process that I'd love to see automated.
AKMC 117 commented
I'm surprised that this has so few votes;I was going to raise this myself but since this is already here, I've voted for it. I think that one of the reasons is that so few people use styles, and one of the reasons that they don't use styles are (a) They don't "cascade" the way Word styles can (where you can base a style on another style, which can be based on another style, resulting in a change at the top of the tree flowing down. Themes are only a partial solution to this), and (b) Because they can't be used for conditional formatting. In my view the second is the greatest impediment to more people adopting styles.