Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table including the actual results (sales) and targets per country and per product (see an example below). I would like to create a conditional formatting as follows: if sales higher or equal to target -> green; if sales lower than target -> red:
Can you please assist how to do this? I need to include both sales and target values in separate columns in the table, because the users need to see the actual sales & target values (not the difference or %).
Thank you in advance!
Hello @a-5
You can do it using the "Background Color expression" configuration for each column in a simple table.
As you have the target next to the sales, you can use a formula like this:
*The colors "lightgreen()" and "lightred()" can be changed for HTML color codes, if you want different tones
Attached is a QVD example.
Hope its helpful.
Hello @a-5
You can do it using the "Background Color expression" configuration for each column in a simple table.
As you have the target next to the sales, you can use a formula like this:
*The colors "lightgreen()" and "lightred()" can be changed for HTML color codes, if you want different tones
Attached is a QVD example.
Hope its helpful.
Hi Javizh!
Thank you so much - it works perfectly!
-Anna