 Yn y ydych chi'n gweld bethau, rydyn ni'n ffordd a'r ysgol yma'n eu hwnnw i'r ffordd. Yn y ffordd, yna ymddi'r ymddi a'r ysgol fyrdd, a'r ysgol yma'n ydwy'r ysgol yma'n ymddi'r ymddi'r ymddi. Dyma'n gweld bethau'n gweld a'r ffordd, ac rydyn ni'n wneud eich ffordd o'r ysgol. Felly i'r rhaglen y tais gweithio, y tais ddechrau'r ddechrau, rydyn ni'n hynny yw, y Llywodraeth B4 yn gyhoeddfa'n gweithio y Llywodraeth B3 yn cael ei ddweud 25% o'r Llywodraeth B3. nes yw 25%. Mae hynny, nad oedd yn ffals, dwi'n dref iawn i'w petrwyd i'r Ffals, mae yw rywbeth y gallu cael ei fod i fynd i'w ffordd i mleidio mewn ffordd coresol. Nid oes yw cael eu swyddiad cwmplech mleidio i'w Ffals i'w teimlo, a nhw fyddwch ddwy byddn o bwysig ferwysgol ychwaneg y gallu gwneud eich cylliddau mewn y swyddfa, y gallwn ni i wedi gwneud cylliddau serlladau. Yn y ffordd, maen nhw'n gydag y perff winninga, dyma ffrind. Yn Ceyn, ac rydyn ni yn cael eich ymddangos, yw Ysb4, byw ychwaneg a yw B3. y 70% o'r tawgwch. Y tawgwch yn 25%. Y tawgwch yn plus 70% o'r tawgwch yn 25% ac yn y b4 yn y b3 yn y b3 yn y tawgwch. Does that say true!" Hi my not cert… By getting these formula results working in a true and false way you can then copy these results in where you want to apply the format in. So let's just try the two we've looked at. I can copy this formula so I can highlight the formula in the formula bar and I can have a copy or use control C so I'll just copy it. Now I'll just press escape to come out to the formula. Go into highlight the area that I want to apply the green to. I want to see whether the green affects any of these cells for the months of the year. So where it becomes greater than 100% of the target increase. I'm going to say show me the green colour. So I can go to a new rule, formula, use control V paste in. So there's the formula just copied which has now come from a test area. I want to form up that green colour I can see it. So I'll go for the full green. There it is. Once more. There we go. We see the green test now is showing us where the test which is greater than 100% of the target increase has actually happened. So the months now are showing me that. For test the yellow test. Now we tested it on, we started test on B4. So that means that we tested B4. That means B5 would have to be yellow because it's true. When it's true on the test, that means whatever you've tested has to come up the colour of the true. So B5 is going to have to be yellow because it's tested true. And there will be other cells along here which will also go yellow. So let's test it out. Let's escape again. I like the cell range. We were in the effect of colour. Let's finish that formatting. When you've got more than one formula, I'd advise you to go to manage cell rules. And then just create a new rule from here. And then formula, copy it in, control V. Give it the colour you want. On this example it's a yellowy colour. So that's something like a colour. That's pretty similar. Okay. Once more. I can even click apply and see what happens with the box still open. As soon as you click apply, I can see whether yellow is applied. And like we said, B5 have to turn yellow because the result was true. I trust the test is already tested true. And I can click OK now to close the box down. We can see that when you've got formulas, you can, as long as you've got a true and false result, this can be then copied into the area where you want to apply the conditional format in for any formulas. For a second example, which I'll now demonstrate, here I've got green, red, and I'll just do the green and red test. So it's quite a long formulas testing. This time it's using an if and a non-function. So it's saying if the cell B2 contains IT skills and E2, which is number delegates, is greater than or equal to 5, or B2 equals business sales and E2 is greater than or equal to 5, then show true or show false. So usually an if when you use it in standard purposes, you want something other than true and false. But for conditional format then true and false is all you're looking for. So all we've typed in show true or show false according to the test. This has been tested against B2. And E2, and what it's saying is B2 and E2 don't meet this particular criteria. And we can see that because number delegates is blank. But if we now apply this formula to the whole of the data by copying and pasting, you can see what the animal turned green. So I can highlight, copy. It's going to press the escape key to come out to the formula. Now highlight the area on a conditional format in true, which is this area in this example. New rule, formula, control B, and format. I want this format to be green. Now we can see where the green color now that the test comes to. So all of the green area now is greater than 5, which it is. And it also equals business skills or IT skills. So that's proven true. We'll now do one of the true tests. I've got a red one. We can see they're quite meaty nested functions. So to try and write this in the conditional format informer area with all these inverted, all these commas, inverted commas, dollar signs. It's not easy. So this is where the tests really, really help. So testing areas like I've used here really do help with conditional format informer when they are quite complex, like these kind of examples. So I'll do another one now. I'll copy this formula. And this will be the last one I'll just do. I'll just show the red as well. So we'll see where the reds are and manage rules. New, control B, OK again. Apply, OK. Now because these are the other tests, as you keep adding the tests, the different colors then will start overwriting other colors. So I've only tested two. But if I kept on testing, testing, they would all then go according to their own test. So each one, if I went for the yellow, that would then look for the yellow. I'd highlight all the rest and the yellow would apply. And then the white would apply. So for example, the one with blank, choose this one here. And this one you need to add this one. This one would go white because there's nothing in it. So when you keep on copying the test results across, the colors will start changing according to the test that you've set. But this now demonstrates the power of actually creating test areas for conditional formatting formulas or functions, particularly complex ones like the ones you can see on screen here. And then copying them into the conditional formatting area instead of creating them in the conditional formatting area. Because it's a lot of tests and a lot of writing in a small little box area. But when you test it in Excel in a testing area, you can then see how it works. Make sure you get true and false and then copy. So this completes the training video on using testing areas for conditional formatting and then copying it to the conditional formatting former area. 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.