00:00in my previous excel tips and tricks video i demonstrated how you can show formulas in excel
00:05today i'm going to try to tackle the same quest on how you can show formulas in google sheets
00:10technically there's two ways to do it the very first one is to use a hotkey control
00:15tilde on your keyboard tilde is located on the top left hand corner of your keyboard
00:19so when you press that key what this does is that basically it displays all the formulas
00:24base that's being used on your data set table here and all the formulas are treated like a
00:29text with that being said you can press ctrl f to do a massive change in your formula using search
00:36and replace let's say for example if you don't like the sum function you can basically do search and
00:41replace sum into a max and all the location where they have sum in it on column c will be
00:48replaced
00:48with max if you want to go back to your original spot where the data set was doing formula calculation
00:55you hold down your ctrl key and press tilde one more time and you're back in your original data
00:59set the second technique is to use a function called is formula is formula accepts only one
01:06argument the argument is the cell location where you want to test whether that particular cell
01:10has a formula let's say for example you want to test cell location c2 you're going to do like that
01:16close parenthesis and hit enter if cell e2 has a formula you'll return true if cell doesn't have a
01:24formula like this guy here i'm testing for cell c1 you can see c1 is basically just a text it
01:32doesn't
01:32have a formula it returns a false well you can use the is formula to your advantage along with
01:38conditional formatting the following way so you're gonna first select your cell where you want to put
01:44conditional formatting to go to format go continue formatting on the right hand side where the menu
01:51appears you're gonna go here and select custom formula is and basically you're gonna say is
01:57formula again like what you did just now open parenthesis let's say if you want to test for
02:04formulas from ranging say a 2 all the way down to the very last row on cell c oh sorry
02:13column c you're
02:13gonna type like that and then let's say for the sake of differentiation i'm going to change to a
02:18different color say red and click done you can see any cells that has a formula will be highlighted
02:25in red using conditional formatting
Comments