Conditional Formatting Full Course
This comprehensive course on conditional formatting in Google Sheets teaches you how to effectively highlight and visualize data using various rules and styles, transforming your spreadsheets into powerful tools for analysis.
It took me a long time to realize that conditional formatting could be really fun. I thought it was just highlighting some cells . I'm gonna show you each and every part of conditional formatting so you can actually become way better at it and use these tools whenever you want.
edit that range here in apply to range .
Now, the rules is going to be the main brain of your conditional formatting, and you have a lot of options here.
Then we have dates, is the date this? Is the date before or after?
The last option, which is actually the most infinite option, which is Custom formula is .
You can also strike through if you want, which I actually find fun to do with checklists.
I do wanna recommend, just in case you haven't seen it, I have another video about low lighting.
So in this case, we're looking at the sales amount, and we wanna see, like, highlight the most and the least.
I'm gonna change these colors.
Now we'll see that, yes, the highest number is dark green.
We also have percentile Percentile So we have some really cool options here.
conditional formatting along a range .
If we go into it, we cannot delete it from inside of the conditional format .
So this sales amount, say I have this 130 sales and I wanna highlight it.
it's going one down because it's B3.
relative with these dollar signs.
We can sort of delete those if we want.
make future videos from those questions.