0:00
hi in this video I'll show you how to
0:02
quickly highlight all formula cells in a
0:04
worksheet using VBA and conditional
0:06
formatting this is especially useful
0:09
when you're reviewing a worksheet with a
0:10
lot of data and formulas making it easy
0:13
to see where formulas are applied let's
0:15
get started first we'll start with
0:17
conditional formatting this method
0:18
doesn't require any coding so it's
0:20
perfect for beginners start by selecting
0:22
the range of cells where you want to
0:24
identify formula cells if you want to
0:26
check the entire worksheet press contr a
0:30
now create a new conditional formatting
0:33
Rule and enter this formula this formula
0:35
checks if a cell contains a formula
0:38
since we're applying it to all selected
0:39
cells Excel will automatically adjust
0:42
the reference for each cell next click
0:44
format and choose a color to highlight
0:46
the formula cells I'll go with a light
0:48
color for easy readability click okay
0:51
twice and now all cells with formulas
0:54
are highlighted in your chosen color
0:56
this method is great if you prefer a
0:57
straightforward no code approach to
1:02
cells next let's highlight formula cells
1:05
using a VBA macro this method is helpful
1:08
if you want a quick solution without
1:09
needing to set up conditional formatting
1:11
each time press alt f11 to open the VBA
1:14
editor then go to insert and select
1:17
module to create a new module here's the
1:20
code you'll need this code Loops through
1:22
all cells in the used Range of the
1:24
active sheet for each cell it checks if
1:27
it contains a formula using the has
1:29
formula property if it does the cell is
1:31
filled with a light yellow color you can
1:34
adjust the color by changing the RGB
1:36
values if you prefer a different
1:37
highlight color to run the macro close
1:40
the VBA editor press alt f8 select
1:43
highlight formula cells and then click
1:45
run instantly all formula cells in the
1:48
active sheet are highlighted with a
1:50
specified color to clear the highlights
1:52
just select the range with the
1:53
highlighted cells go to home select
1:56
clear in the editing group and then
1:58
choose clear formats and that's it thank
2:01
you for watching please share this video
2:03
and don't forget to like subscribe and
2:05
hit the notification Bell for more Excel
2:07
tips and tutorials your support helps us
2:09
create more valuable content See you in
