Make Negative Numbers Turn Red in Google Sheets 2 Ways

hi there jamie here today at teachers tech hope you're having great day today today want to show you two different ways you can format cells to turn negative numbers red in google sheets like this my google sheets is open without any formatting here i've just inputted some random numbers so you can go ahead and just do this on the sheet that you're working on too if you're following along but i'm going to go ahead and select the area and i'm going to say all this area is what need to be formatting so there's two different ways i'm going to show you how to format the first one if go up to format here i'm going to go to number and take look at the very bottom where it says custom number format so i'm just selecting this now as click on different ones it's going to give you an example what positive and negative so this is the one want if wanted dollar signs to show up this is it all right you can take look at the other ones too as you go down the list this one for example if you're entering zero it would become just the dash like this and gives an example with text but for what want it's right here so if go ahead and apply this now it's applied the dollar signs remember could apply it without the dollar signs just would have to pick different one now anytime go and enter number so if this is positive here and this one's negative all have to do is go ahead and enter it and it will just adjust showing that color and remember formatted it down to here so if enter another number down here it will also turn red now want to show you second way now that you can do this to format cells that also can turn it red so now i'm going to use conditional formatting in google sheets i'm going to select the range again so this area right through here go up to format and this time look for conditional formatting and know i'm talking about just changing negative numbers to red but if you take look at other things you can do in conditional formatting if go over to color scale scale you can see how it's adjusting colors based on the numbers and can go through and format any of these two but that's not what i'm talking about in this video i'm going to go over to single color here and so have my range that i'm selecting and what's the rule so the rule is going to be if it is less than what well it's going to be less than 0. what do want to have happen now you could look at it couple different ways do you want maybe cell to be read so could make the cell stand out just like that but in this case just want the font again so if just drop down choose my font like so and hit done and now you can see that it is all the negatives are red and if go ahead and enter another one in and that will also turn red so can go through and format it with the dollar sign to if wanted the dollar sign right after that so that's just quick tip on some formatting with the number and conditional formatting in google sheets how you can turn your negative numbers red hope you like this quick tip here tonight in teachers tech i'll see you next time with more tech tips and tutorials