Excel is well known for making ... In my case, I've used the Currency number format with 0 decimal places and negative values formatted in a red font. Use the Format Painter tool to copy the ...

The rule is simple: If the current value is less than 0, meaning the current value is a negative number, the expression is True, and Excel applies the format (the red font). Image: Susan Harkins ...