okay so in this video i'm going to show you how we can highlight
all formulas in our worksheet in google sheets and excel
so i'm going to start with google sheets and we'll go back to excel in just a second so the reason
you may need something like this is just to keep things organized because when you start having a
lot of things going on in your spreadsheets it's very hard to tell sometimes where are the formulas
where are things that are just inputs so we don't want to probably go to each cell
and check like if i click on this i can see here it's a formula i click on this see it's a formula
that seems to be a formula too see but which ones are formulas and which ones aren't right
could be a lot of different things happening like this one see it's not a formula it's just a number
here and sometimes when there is a spreadsheet that's thrown at you it might be useful just to
have some sort of understanding where do we have formulas here and where do we not have formulas
well one thing you could do you could just display all the formulas in google sheets
we can do that by going under view and do show formulas and see it will reveal all the formulas
now i don't find this that useful very often because it basically just makes things look too
busy and still hard to understand so that's why i prefer to do some color coding instead
so the way we can do that color coding i'm going to just select this entire spreadsheet by clicking
in this top left corner and then go to format and do conditional formatting and as you can see
there are already some conditional formattings in this spreadsheets we don't care about that
i'm just going to go ahead and click add another rule and here i'm going to do my own rule for the
spreadsheet and what i'm going to do i'm just going to switch this to a custom formula which
is the last option all the way down here and then as my formula i'm going to do equals ease formula
a1 a1 being this top left corner now as you're doing this you want to make sure your active cell
is actually a1 so as you can see my active cell this blue one is a1 and now i can just choose my
color so you can either do some sort of background color if you want you can also do some sort of
text color if you prefer that like this i'm just gonna do a background color on this i'm gonna do
num for that and we'll choose some sort of color here i'm just gonna go with this yellowish color
maybe let's go with a lighter version i'm gonna hit done and you should be able to see
how all of these get highlighted because they are formulas so as you can see these are all formulas
now and they're all highlighted and if i click on it see there's a formula and this should not
be a formula see it's just text so now we can clearly see where the formulas are we can also
see there are all formulas here see even though there's nothing happening here it's just blank
but now it's easier to understand what we're working with so the same type of thing you can
do in excel so if i go to excel you can still show all your formulas if you go to formulas
see there's show formulas here and that will do the same thing we got in google sheets i'm
going to uncheck that but i'm going to do that conditional formatting again so i'm just going
to click in this upper left corner again we want to make sure our active cell see this white one
is the active one and at this point i'm gonna go under home
conditional formatting and then create a new rule and the last option here all the way down here
is use a formula to do your conditional formatting so i'll just go here and do equals
is for mueller a1 again the same exact thing i just did in google sheets and then we want
to choose some sort of format so i'll click on format so feel would be your background color
and font would be your text color background is good enough for me i'm just going to press ok ok
and again you'll see that every formula cell is highlighted if i do another formula here
and do like this minus this hit enter because it's a formula now it's automatically going to
get the color if i overwrite the formula see it's a formula here and do a number
it will lose the formatting because there's no formula there and that should do it for
this video thanks for watching please subscribe and i'll see in the next one