Ask Questions

Connect

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
684 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

by Uniqueton (170 points)

1 Answer

1vote

polle Points90570

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.

by polle (90.6k points)
selected by

1vote

Uniqueton commented

Thank you for your quick reply!

by Uniqueton (170 points)
edited by

1vote

polle commented

Glad to help.

by polle (90.6k points)

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

by Uniqueton (170 points)

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

by polle (90.6k points)

Please log in or register to answer this question.

Related questions

Notion Fusion

Without Answer

Exclusive for Notion Answers Users

Recent Activities

...

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!

Tags

Connect