From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use conditional formatting to highlight formula cells only
From the course: Excel 2016: Tips and Tricks
Use conditional formatting to highlight formula cells only
- [Voiceover] On this worksheet called Formulas, there are lots of formulas, and we can see them all by going to the Find & Select button on the far right side. Before using this feature, make sure you click a single cell, not two. If you click two or three or four, it only looks within that region for formulas. Click on a single cell, and it almost, a counter-intuitive way, it will look throughout the entire worksheet. Find and Select, Formulas, all the formula cells are highlighted. We could add a color; last time I used this Fill Color bucket, it was green. That's a light color, I could use that for sure. And that's good. Now, if I erase this cell here, it's still green. If I write a formula up here, it doesn't turn green. So the feature, although good at first, isn't dynamic. Let me undo those two last actions. We can use conditional formatting here and have this feature be dynamic and always up-to-date. I'm going to click in the upper left-hand corner, that selects the entire…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
(Locked)
Use keystroke shortcuts for frequently needed numeric formats6m 29s
-
(Locked)
Accentuate data with alignment tools6m 2s
-
(Locked)
Add a color background to every 5th row in a range5m 40s
-
(Locked)
Use conditional formatting based on comparison criteria5m 13s
-
(Locked)
Use conditional formatting to highlight formula cells only2m 54s
-
(Locked)
Create custom formats: Dot leaders and more6m 1s
-
(Locked)
Use special formats for times over 24 hours4m 9s
-
(Locked)
Add/remove strikethrough and borders with keystroke shortcuts3m 34s
-
(Locked)
Quickly format phone and SS numbers3m 54s
-
(Locked)
-
-
-
-