Changing colour of a number in a cell

axelrodo · 03/23/23

Hi, I'm trying conditional formatting to change the colour of a number in cell from black to red if the number is negative. It tried: "If ACTUALS (in the ACTUALS column which the cell is located) ARE LESS THAN $0, then apply BOLD and RED. But it didn't change the colour.

I tried: "Contains $- but nothing changed either.

Do you know of a solution?

Thank you,

Axel

Andrée Starå · 03/24/23

Hi @axelrodo

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kaveri Vipat · 03/24/23

Hi axelrodo

I hope you are doing well,

According to the condition, I would suggest creating a helper column and apply this formula

=IF(Number@row <= 0, "Negative", IF(Number@row > 0, "Positive", ""))

Now you can apply conditional formatting based on the helper column if the helper is equal to negative then the number is RED and BOLD.

I hope this is useful to you, Have a Good Day.

Thanks

Kaveri Vipat

axelrodo · 03/24/23

https://community.smartsheet.com/discussion/comment/368819#Comment_368819

Hi Andrée, see picture attached. I have a formula that calculates the difference between income and expenditure. I'd like the number, if negative, to show in red.

axelrodo · 03/24/23

https://community.smartsheet.com/discussion/comment/368822#Comment_368822

Hi Kaveri, I need to explore what a "helper column" is 😉. First time I hear about it. Ideally I'd like to avoid adding another column. But I'll see if that could be an option. Thank you.

Changing colour of a number in a cell

Answers

Categories