23 - Libre office - Calc, open office - Calc, excel tutorial - Conditional formatting

for those who want to download the worksheet for the next examples go to thefrugalcomputerguy.com video tutorials and then office - spreadsheet and down at the bottom that page I will add the download link for the .ods spreadsheet now we're going to mix the conditional and the formatting and bring it all together so what I'm going to start with here is I"m going to click on this accounting and I want to go into format conditional formatting I want to say - If the cell value is equal to and I'm going to use a double quote Accounting - typed out and then another double quote the cell style it's set at default we want to change that to... We're going to create a new style a lot of people from Excel are going to see this too because you have to create a new style - but I could choose from the blue default or the blue heading that I have but, I'm going to select new style and I'm going to call this new style... Accounting to make them stand out I'm going to give a yellow background and i want my font to be bold I'll click okay and we see bold yellow accounting and I want this format to be for the column so I will click on the paintbrush there and highlight all of this column... all the way down anywhere it has accounting stands out - so that's kinda handy we can also use this to make people's age... let's say to format conditional formatting we want everyone under 40 - we need to select less than 40 - We want to create a new style and if I don't give it a title it will remain untitled and I"m going to change the background to green we'll make it a brighter green than than and a second condition is if it is greater than 40 We want to say greater than or equal to 40 we will make our new style untitled 2 and it'll be a background gray 20 percent clicking okay this one shows a green but we still want to apply this to the whole column instead of just this one so I will click on the format paintbrush highlight the whole column - now things standout Why didn't our people turn gray? Let's go back into our format We'll check that format conditional formatting if it is less than or equal We had less than for everything, we need to say greater than or equal to now we should be good and again I need to copy this all the way down now we should be all set. and there we have the gray or 40 and green under 40 another thing we want to check for would-be blanks these are nothing so I will... I'll start with it here because it is easier to copy from the top clicking on format... conditional formatting I see if cell value is equal to nothing - I will use the account style There's our accounting style and we don't see anything because this has a value in it, when I do the paintbrush see that the the blank ones standout as yellow we can also do this with... refer to a different cell see here we have a last name Taylor and i want to format this as conditional formatting to change things up we are going to give it a new style untitled 3 we are just going to change font - let's make it bold and italic we want to say IF instead of equal to the cell value we want to say formula now we want to say if we are in B5 so I want this to have L5 - I need to have equals =L5 = "Group D" and we click okay so we can see that he is italicized but he is not bold let's fix that format conditional formatting actually, I'm just going to go in through here show that we have our untitled 3 and I want to modify that so I wanna make it bold and Italic Let's also put some borders around it just regular borders - now we can see it and we want this one as well so if I copy this format over and we're gonna have a quick change with that because we need to say format - conditional formatting formula m5 - we want to change this to L now we got them all and we use our little paintbrush and we can see everyong in Group D is now bold italicized we've done our ages so we've got a little crazy with our formatting here but you get the idea you might want to do a lot less but I just enough to point out the things really matter but that this was just to demonstrate how the different was of using conditional formatting all all cool all