Post

7 followers Follow
7
Avatar

Apply row based conditional formatting

It would be useful to be able to apply 'row based' conditional formatting as well as the current individual field based formatting.

Rationale: There are occasions when it is appropriate to highlight a whole row in a particular view. At the moment you have to add conditional formatting to every field in the row individually which can be time consuming (Especially if the condition is complex involving multiple fields and/or values). There is also no current way of copying conditional formatting from one field to another.

Suggested Approach: Allow the user to select a drop down for conditional formatting on the entire row. Still allow for individual field formatting to apply 'on-top' of any row based formatting. This would allow for some very specific formatting to be applied.

e.g.: A condition occurs where the whole row needs to be highlighted with a background colour of light red. This get applied as the row based conditional format. However a couple of fields need their text to be bold or a different colour based on another condition and this can still be applied at the field level 'on top' of the row based formatting. As a rule, any duplicate/conflict between the two should be over-ridden by the field based criteria..

Thanks for listening.

Gregg Holden Not planned

Official comment

Avatar

Thank you for submitting this feature request, for future reference the request ID is CR-277658

Danielle Lasirona
Comment actions Permalink

Please sign in to leave a comment.

8 comments

1
Avatar

I was looking for the exact same thing today! Thank you for asking!

Erin Brotherton 1 vote
Comment actions Permalink
0
Avatar

Hello Erin and Eric, I have added both of you to the list of requesters for this feature request.

Danielle Lasirona 0 votes
Comment actions Permalink
0
Avatar

Hello Peter, I have added you to the list of requesters for this feature request. 

Danielle Lasirona 0 votes
Comment actions Permalink
1
Avatar

Just to add to this...

Make your FIRST UAT TEST encompass the abilty to HIGHLIGHT a row that has a DUPLICATE value in one of the fields.

Let's say you have a Customer Email field\column, then highlight EVERY ROW that has a duplicate value.

 

This is possible in Google Sheets natively and in Excel Online with a Plug-In, so maybe Clarizen can add this functionality, because you can highlight DUPLICATE values across columns, but not across rows OR even highlight the row...

Wilfredo Maldonado 1 vote
Comment actions Permalink
0
Avatar

Is there an update on this request?  I'd like to be added.

Bekah Ewig 0 votes
Comment actions Permalink