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

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

1 Answer

1vote

polle Points79930

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.

1vote

Uniqueton commented

Thank you for your quick reply!

1vote

polle commented

Glad to help.

0vote

Uniqueton commented

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

1vote

polle commented

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 "$" +.

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect