- All right,
if you're using Google Sheets
and you have a table of data like we do right here,
and you want to create some functions
that use the color of the font
or the color of the background,
we're going to go over how to do that right now
and we're going to be using a plugin called Power Tools.
And within that,
we're going to be looking at process
and function by color.
All right, so it's a relatively simple menu
that comes up,
and the first thing that it wants you to do
is just tell it where we're going to be doing this.
So let's say that we come into this table on the left,
and we wanna know the total,
so this is just a simple sum function
of the red font.
And then we'll do the blue font,
that's probably not called blue,
what's that called.
Close to blue 11, okay,
but you don't have to worry about that,
it'll do it automatically.
So let's come down to the bottom,
and this is where typically
you would just type in the function, right?
So equal sum and then you would type in the range,
but that is not aware of the color.
So if you use this plugin,
we're going to select the range,
so you could type it in,
but I'm going to left click on this little grid,
and then that will let me come over and select
F2 to F16.
Left click on okay.
So now it knows the range
that we want to perform this function on,
we're going to select the color,
so left click on the dropper.
And in this case,
we're going to select the color in F2, click okay.
And if you look here,
it's already showing you that's the red font color,
and we can also look at background color,
and in this case,
it did pick it up and it's white.
You can uncheck that if you want,
but you can also just leave it on
because all the background colors are white.
It's not going to make a difference in this formula.
And then, the function that we want to use,
so there is a lot of functions available.
The most popular functions,
so you can add them,
you can also count,
which we'll do next,
and then different types of operations
averaging the top and the bottom.
And you can multiply,
and then you can also do some statistical analysis
if you want to,
well, we're going to do some.
And where do you want the results?
We want just to put the results
at the bottom of the table.
So we'll leave F17 in here,
you could change it if you wanted to.
And then you're getting a little warning
saying, "Hey, be careful,
"this won't update if you change colors,
"it will only update if you change values
"or use the refresh results option."
So just be mindful of that.
So we'll insert the function,
okay, there it is.
So 1241, let's double check that.
I will highlight all of these cells with the red font
and we'll look in the lower right hand corner.
And we'll change this to sum,
so that's right, 1241.56.
So what you could do,
if you wanted to,
is just have all the red ones here,
and then you could do the blue ones.
So we'll pick up that again,
it'll be very similar,
so you don't have to change the range.
You would change the select color,
so let's use the dropper and come over
and grab that color.
Leave it on sum,
but this time let's paste it into F18.
Left click on insert function,
and it puts that one in.
So if you look in the cell where this is happening,
it's created a custom function
called values by color,
and the white is the color of the background,
and this html color code is the color of the font.
So if you wanted to,
you could copy and paste this formula
and then just change the colors inside of it,
if you wanted to work a little bit faster.
But it is much easier just to use this menu.
All right, let's come over
and look at a different functionality,
so we'll go into B17 and work a little bit faster here.
We're just going to change the range using our keyboard.
Right, we're gonna go B2 to B16.
And we'll use one of these functions that works on text,
so we want to just count the cells that have text
that are also highlighted in yellow,
so we'll left click on that.
And I don't think I updated this input yet,
so we will select the color by left clicking in cell B5
which has the yellow background.
Okay, so you see,
it's picked up the black font
and the yellow background color.
So let's just say maybe the fonts are different colors
and you don't want to differentiate between those,
just take that check mark out.
We'll do count A,
which is just counting the cells
that are not empty.
So it will pick up the cells that have text in them.
And then we're going to paste the results in B17,
so left click on insert function,
takes a minute to update,
but there we go.
So it put a three in there,
let's just change that font color.
And that counted the number of cells
that have text in them with yellow background.
So again, this is a plugin called Power Tools.
I do have the link in the description,
and if you use that link,
it will help to support my channel,
which I would appreciate very much.
All right, next up,
we're going to talk about how to make your own
interactive checklist in Google Sheets.
And when you check off your task,
it crosses out your to-do,
so it's pretty cool.
See you in that video, thanks.