Create Onlooker Conditional with airSlate SignNow

Create backer conditional

today i want to show you how you could use conditional formatting in microsoft excel now conditional formatting is a really valuable tool that you could use to visualize your data and to see trends and patterns in your data it might sound a little terrifying but it's really not let's jump into it and i'll show you how to do it so here i am in excel and just as full disclosure before we get going here i work at microsoft as a full-time employee okay well so how can you work with conditional formatting well let's say that i'm a teacher in school and let's say that i just recently had everyone take a test on i don't know maybe conditional formatting and so these are all the grades that came back we have some people who performed well and others who didn't perform so well of course if i were the teacher i would expect all the grades to be a little higher but hey we're just doing this as an example so let's say i have all these grades and i want to see who performed below in 80. so what i could do is you have this button up here under the home tab called conditional formatting if you hover over it you'll basically see what it does so once again you can see trends and patterns in your data and so let's click on that and let's try it out so the first item we see here is highlight cells rule and what i could do is you see options like greater than so if the value is greater than something you can highlight it if it's less than something you can highlight it that's exactly what we want to do we want to see people who scored below in 80. so i'm going to click on this option and what i want to do is let's say if they scored below in 80. so i'll type in 80 there and what i could do then is i could format the text in different ways so i could do a light red fill yellow green uh we're not going to do a green because it's not a good thing when you get a low score on a test so we're going to go with the red but i can also do you know red text red border i could also do custom formatting so let's say i wanted to bold it i wanted to highlight you know pretty much anything i want to format it with i could do within this view but i'm going to cancel that and come back to here and i like that the red fill so i'll just click on okay and so here very quickly now you'll see all these people so sophia she got a 76 so she's working hard but didn't quite make it uh anise i don't know what to do with her she just...