color

How to count colored cells in Excel

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

in this video I'm gonna show you how to

count colored cells that have been

counted that have been created by you

manually this is when you go through the

cells in a document and you want to

highlight some of a particular color and

then you would go to the Home tab and

then you would simply hit the fill color

and then you'd color it green or

whatever else as opposed to the other

the other cells that I have here which

is the ten here if you go to the Home

tab and you go to conditionally format

and you go manage rules you can see that

this was conditionally formatted because

the value is greater than nine and

obviously it's greater than nine if it's

10 and the same thing goes for six if

you go to the Home tab and you go manage

rules you can see that it is value is

less than seven so it turns red by