Changing colour of a number in a cell

axelrodo

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å

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

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

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

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.