Custom Column Colouring

Sammiip01 · 03-14-2021, 07:07 AM

I've recently discovered column colouring and i have set up the colours so far.

When i fill in the "Completed Column" to completed it turns red.

I have "M/A" (multi author) column that turns purple when it filled in.

Now im struggling to set a rule that if column "completed" and column "M/A" is filled in, i want it to turn Green.

Can someone show me how to get this done?

theducks · 03-14-2021, 10:42 AM

A rule can't do 2 different things, so you need to have 3 rules: A, B and AwithB

Use the "add another condition" button to add that second rule.

The ORDER of rules (in the rule list) is adjusted with the Green arrows on the right You have 2 rules changing a single column. The last one in the list Wins

03-14-2021, 07:07 AM	#1
Sammiip01 Junior Member Posts: 3 Karma: 10 Join Date: Mar 2018 Device: kindle voyage	Custom Column Colouring I've recently discovered column colouring and i have set up the colours so far. When i fill in the "Completed Column" to completed it turns red. I have "M/A" (multi author) column that turns purple when it filled in. Now im struggling to set a rule that if column "completed" and column "M/A" is filled in, i want it to turn Green. Can someone show me how to get this done? Attached Thumbnails

03-14-2021, 10:42 AM	#2
theducks Well trained by Cats Posts: 31,060 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	A rule can't do 2 different things, so you need to have 3 rules: A, B and AwithB Use the "add another condition" button to add that second rule. The ORDER of rules (in the rule list) is adjusted with the Green arrows on the right You have 2 rules changing a single column. The last one in the list Wins Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tip for those using emblems/column colouring/column icons	ownedbycats	Library Management	0	07-05-2020 07:07 PM
Using RE to extract pattern from custom column into another custom column	activedirectory	Library Management	1	12-15-2019 08:07 PM
Move selected data from series column to a new custom column	fvdham	Library Management	3	06-02-2017 03:49 PM
Custom column returns value based on value of another custom column?	calvin-c	Calibre	3	09-14-2013 02:24 PM
Column Colouring	JayLaFunk	Library Management	11	11-01-2011 01:55 PM

Advert