Conditional color formatting for column values

Started by Aaron

Aaron

Conditional color formatting for column values   14 October 2016, 06:48

Hi Andrew and the SoftPerfect team,

Love this program and the flexibility it provides. Is there any possibility of being able to apply conditional formatting - primarily just a different background colour - to column cells? E.g. if cell value <> XXXX then change the cell background color to CCCC (similar to how the existing filtering works). Would make it much easier to visually identify items that aren't similar to others. Thanks smile
SoftPerfect Support forum - Andrew avatar image

Re: Conditional color formatting for column values   14 October 2016, 21:12

That's a great idea - added in the latest builds. Please test and let me know if you are happy with how it works.

SoftPerfect support forum
Aaron

Re: Conditional color formatting for column values   20 October 2016, 10:07

Wow that was fast! Absolutely brilliant smile
Works great ... only thing I can think of that'd turn it up a notch would be the ability to add more than one condition (similar to the filter method, where multiple filters can be added), but how you've got it working now works great for what I need. Thank you!!
rmpf2

Re: Conditional color formatting for column values   21 October 2016, 00:28

Hi Andrew. Please consider the ability to add more than one condition like in filters. In some special situations when you choose to enable a column with something like the following:

Example - Looking for a service like seclogon - Alternatives might be disable, manual, etc.... But admin needed to be auto.

column color - red
Condition - Does not contain
Value - auto

It works for everything else but also for empty cells. So to disregard those empty values a second condition might be needed.
SoftPerfect Support forum - Andrew avatar image

Re: Conditional color formatting for column values   21 October 2016, 10:30

May be in future releases. At the moment if you want to highlight the rows that don't contain "Auto" and are not empty, you can simply change the font colour, rather than the background.

In that case blank cells are simply disregarded:

SoftPerfect support forum
rmpf2

Re: Conditional color formatting for column values   21 October 2016, 14:40

Thanks!!!!

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • Write in English. If possible, check your spelling and grammar.

Author:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 **      **  ********  **    **  ********  ********  
 **  **  **  **        ***   **     **     **     ** 
 **  **  **  **        ****  **     **     **     ** 
 **  **  **  ******    ** ** **     **     **     ** 
 **  **  **  **        **  ****     **     **     ** 
 **  **  **  **        **   ***     **     **     ** 
  ***  ***   **        **    **     **     ********  

Message: