How to Show Negative Numbers as Red in Excel

I’ll show you three methods for showing negative numbers as red in Excel. Use whichever you’re most comfortable with or works best for your sheet.



Chapters:
0:00 Intro
0:23 Format the Cells for Negative Red Numbers
0:53 Create a Custom Format for Negative Red Numbers
1:25 Use Conditional Formatting for Negative Red Numbers
2:23 End screen



What you’ll learn:
1. Format the Cells for Negative Red Numbers
a. easiest way to format your negative numbers red
b. How to see any negative numbers in your selected cells turn red while the positive numbers remain the same
2. Create a Custom Format for Negative Red Numbers
a. How to turn negative numbers red while retaining the minus signs in front of the numbers
3. Use Conditional Formatting for Negative Red Numbers
a. How to use a conditional formatting rule

















Song: ROFEU – Midnight Lover
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution 3.0 Unported
Video Link: https://youtu.be/A8zChZlq-Ws

#computereverywhere #howto #show #negativenumbers #red #excel