Format negative numbers as red


As a hardcore excel user, I feel like an idiot here not being able to do simple things I’m used to.

How can I format negative numbers to show as red in a table?



You use the “Conditional Formatting” feature which is the icon that looks like “Aa” in the table config settings:


Like this…

/edit- you can choose which columns to change colour, or the entire row if you want. :slight_smile:


Thanks… this is much simpler. Here is what I did an not getting results

I want anything that is < 0 to be red letters (not background). I realize I picked above zero… that’s not working either.


It looks like the problem is that it doesn’t know what number in the table you want to test. You just say “thisTable >0” instead of something like “thisTable.Month 1 < 0”.

/edit - this post might also be interesting. :wink: Listing all columns that are not blank

1 Like