openmolecules.org

 
Home » DataWarrior » Functionality » Column Background Colors
Column Background Colors [message #1111] Thu, 05 November 2020 20:22 Go to next message
ELFritzen is currently offline  ELFritzen
Messages: 47
Registered: November 2019
Location: North Carolina, US
Member
Is it possible to have background colors applied to a column between a range of values? I see how the background colors can be applied lets say from a value of 0 to 5 with 0 being green and anything 5 or above being red. What I'd like to do is to color the backgrounds for values less than 1 red, and values between 1 and 5 green, and values above 5 being red again? Or in other words when the value is between 1 and 5, the back ground should be green. All other values the background should be red. It doesn't look like this can be done in Datawarrior.

Thanks,
Ed Fritzen


Ed Fritzen
Re: Column Background Colors [message #1115 is a reply to message #1111] Sun, 08 November 2020 13:41 Go to previous message
thomas is currently offline  thomas
Messages: 715
Registered: June 2014
Senior Member
You can't do that directly, but if you calculate a new column with formula "if(cLogP<1,0,if(cLogP>5,0,1))" (assuming that your value column's name is 'cLogP'Wink, the new column contains a 1 for cLopP values in the 1-5 range. You can use that new column to color the cLogP column's cells.

Thomas
Previous Topic: Axial chirality
Next Topic: Copy and paste from Chemdraw to Datawarrior structure
Goto Forum:
  


Current Time: Fri Nov 22 03:26:05 CET 2024

Total time taken to generate the page: 0.03680 seconds