From the course: Excel: Conditional Formatting for Beginners
Join today to access over 25,500 courses taught by industry experts.
Identify cells with conditional formatting rules - Microsoft Excel Tutorial
From the course: Excel: Conditional Formatting for Beginners
Identify cells with conditional formatting rules
- [[Instructor] We're looking at the worksheet called Locate Conditional Formatting. Most of the time, when conditional formatting exists, you're aware of it. Often you were the creator of it, but sometimes you're surprised. I've got a worksheet here, maybe I've never seen this before. It's about 900 rows. I'm making some adjustments here and there. This refrigerators here should have been dryer, so I typed in dryers and maybe I lose my train of thought or hurried or whatever. I just typed dryer and I'm kind of surprised 'cause suddenly it's in color. Now obviously I should have typed the S, or at least that's what I'm thinking, but what happened there? Well, I guess there's conditional formatting. I'll put the S in. Okay, I'm not going to worry about that. I do see a highlighted date over in Column F. There's something going on there. If I try and get rid of the color, on the Home tab, if I go to the Fill Color bucket and choose No Fill, what happens? Nothing happens. So there's…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.