 In this training video, we're going to look at conditional formatting formulas using standard formula calculations So for cell C16, I want to compare it Against B16 to see whether it's greater than or less than that particular cell. If it's greater than, I want to color C16 Green. If it's less than, I want to color it red So in effect, this should go green. Then when I've got the formatting I can just use the format painter then to copy it to all the other totals from March to December and apply it so each of The totals then is compared to the previous Total to see where that's going to put down. So you can really see it trends in Totals sort of you. So that's what this is going to do is going to look at trends with it With a date that's going up and down against red or green So these conditional formatting new rule Formula and I'm going to say I want to compare C16 So I'm asking the question is C16 I'll start off with less than less than B16 I don't need any dollar signs because I want the cells to move freely with dollar signs They're held in place these I don't See 16 to be held in place because I want to be allowed to move across to copy to all the other totals when I use the format painter So no dollar signs here And no dollar signs here Okay, I'm gonna format that to say if that's case and it's less than B16. Let's go in a red color Under fill Okay, I'm now going to go back to Condition format this time I'm going to use manage rules because I'm going to apply the second rule using manage rules So there's the first rule the red rule new rule again formula and then I choose is C16 greater than B16 again, I don't want dollars and that's okay. So I'm gonna format it green Choose this green Okay Now the booty boat the manage rules that can apply it straight away. So I'd be expecting the Second now apply I've got two rules. I can apply it. I can see what's gonna happen So I know when I press apply that C16 should go green Which is what it does now click okay You can click on the format painter now the cell is highlighted format painter one single click Because all the cells are next to each other. So I'm only doing a one little row of totals So one click on the format painter I live across and Very cleverly we can now see what's happening here. So just look we look at one of two the colors So March is gone up from February. That's where it's green then April went up from March That's where it's green then we went down so you can quickly see then where the months are going up and down and where the trends coming from so you can then use these colors to manage some kind of business operations to see do a bit of investigation and This can be done through color in this case by seeing what's going up and what's gone down and looking at the reasons behind it But this completes the training video on conditional formatting formulas in this example just using standard formulas where one cell is greater than another cell or The cell is less than another cell and then the color coded accordingly If you enjoyed this video, make sure you like and subscribe to our channel Hope to see you for the next tutorial and thanks for watching