Notion Answers

Help between Notion users

Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Add color to cell in a database table

Asked Dec 31, 2023

394 Views
1 Answers
Solved

Hello,

I have a database table that calculates the profit/loss of stock trading. I want to make this cell show a green background if the number is greater than 0 and if the number is negative the background should be red.

How can I add this to my existing formula?

I tried to play around with the style but I couldn't make it work with the current "if" formula that I have.

Thank you for the help

asked Dec 31, 2023 by Uniqueton (170 points)

1 Answer

1vote

polle Points78860

Use style() in your formula and choose the background color you need.

In the same formula window when you add the style you have examples for bold, italic, color, backgrounds and so on.

answered Dec 31, 2023 by polle (78.9k points)

selected Dec 31, 2023 by Uniqueton

1vote

Uniqueton commented Dec 31, 2023

Thank you for your quick reply!

commented Dec 31, 2023 by Uniqueton (170 points)

edited Dec 31, 2023 by Uniqueton

1vote

polle commented Jan 1

Glad to help.

commented Jan 1 by polle (78.9k points)

0vote

Uniqueton commented Jan 1

One more question,

Before I used style () in the formula, the outcome was in a number format as a currency ($25)

When I add style () to my formula, the number format diapers (25), and I cannot add it back via edit property.

Is there a way to make it happen?

Thanks

commented Jan 1 by Uniqueton (170 points)

1vote

polle commented Jan 2

That is correct, you are removing the number format in exchange for styled text. You need to add the symbol inside the Notion formula with "$" +.

commented Jan 2 by polle (78.9k points)

Please log in or register to answer this question.

Exclusive for Notion Answers Users

• Dynamic Calendar Icon | Info | Download
Add yours here

Extend Notion Powers

⇧Your Product or Service Here⇧

...

Notion Answers

Register & Ask

Get answers

Vote and select answers

Question

Add color to cell in a database table

Please log in or register to add a comment.