How to Show Negative Numbers in Red in Google Sheets (2 Easy ways)
Article Link: https://spreadsheetpoint.com/show-neg...
In this video, I will show you how to quickly show negative numbers in red in Google Sheets.
00:00 Intro
00:25 Using Conditional Formatting
01:38 Using Custom Number Formatting
With Conditional Formatting, you can highlight the entire cell (or can format only the text to show the number in red). With custom number formatting, you can only color the font of the number red (not the entire cell).
Below is the Custom Number Formatting that will show negative numbers in red:
General;[RED]General;General;@
You can read more about this here: https://spreadsheetpoint.com/show-neg...
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc.
You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/
#GoogleSheets #GoogleSheetsTips #Spreadsheet