How To Grey Out Unused Cells

0:00 Here's how to gray out unused cells . Unused cells could also be considered blank cells . I'm going to show you how in this video. We're going to go up to Format , Conditional Formatting , but first we're going to select a column where we want to gray out the unused or blank cells . Format, Conditional Formatting, and right away it says Format Cells If Is Not Empty. We can change this to Is Empty. And change the color to gray. There is one thing I want to point out when we do this. Is that all of the blank cells that are underneath our table or data also are grayed out. So there is another sort of way to do this. Let's go to custom formula is, and we're going to select a custom formula. We're in the D column, so we're going to say is blank D1. Restrict Access to a Cell if Another Cell is Blank How to create a formula for every row in a column in a Google Spreadsheet? How to Change Dropdown Colors and Gray Out Rows in Google Sheets with Apps Script

0:48 This will apply to every single row, even though it says D1, it'll iterate over it. But I want to do one more thing, I want to add an and at the beginning, and have another thing, and then say not is blank B1. And here we need to add a dollar sign to our formula . B in parentheses of and, and there we go. Now, it'll only be gray if we have something in the B column and nothing in the D column. That sort of saves you all of those grayed out cells down below. And I think it's also a fun way to create this sort of automation inside of Sheets with this conditional formatting . Hopefully that was fun for you, and if you're interested in more automations, getting more out of your Google Sheets, subscribe here on YouTube to BetterSheets. Ultimate Checklist in Google Sheets The Simplest Bestest Checklist in Google Sheets Highlight Duplicates of Two Columns