We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Is there a visual indicator for cells with conditional formatting? [closed]

asked 2012-03-30 17:04:03 +0200

TJ Meneses gravatar image

updated 2021-06-04 01:22:12 +0200

Alex Kemp gravatar image

I'll be quick about this; I have no idea whether a cell has an applied conditional formatting or not without having to dig into the Format > Conditional Formatting... dialog box. For me, this is unintuitive and a little annoying if I'm trying to set up more-than-simple cases of conditional formatting for columns of data.

Is there any other way, requiring less clicks, that I can find out if a cell is conditionally formatted? The ideal implementation in my mind is something like the edit state of the document on the status bar (asterisk if edited from last save, check/blank otherwise) combined with the visual cue of comments in cells (a little corner arrow).

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 16:32:45.593857

1 Answer

Sort by » oldest newest most voted

answered 2012-04-04 08:52:28 +0200

hunteke gravatar image

None of which I'm personally aware. I'm a programmer type so when I needed to do a few thousand of these recently, I made a template, picked apart the ODS file, and created a new one programmatically. However, this is clearly neither ideal nor approachable for most, and I would have preferred exactly what you're suggesting.

My suggestion: spend a few minutes looking through the various enhancement requests and "crazy ideas" and if you don't see it, submit this idea.

edit flag offensive delete link more

Question Tools



Asked: 2012-03-30 17:04:03 +0200

Seen: 308 times

Last updated: Apr 04 '12