00:00Let's explore to see how we can automatically add borders around the cell as soon as you add some text in Excel just like this.
00:07Also, we'll see if we can add similar features in Google Sheet. We'll start off with our Excel here in Office.
00:13First, you're going to press Ctrl A to select all the cells on your worksheet here. Now, you're going to go Home Tabs, Style,
00:19Conditional Formatting, and click on New Rules. In the New Rules here, you're going to select Use Formula, and the formula you'll be using is
00:25Equal A1, not equal to, double quote, double quote, and you're going to go Format, and you're going to select this border tab here,
00:33and then click on Outline, click OK, and OK. Now, every time if you enter any text, you can see that every cell
00:41with the text in it will have a border around it. Let's look at Google Sheet to see if we can add the
00:47same feature. In Google Sheet, you're going to press Ctrl A to select all the cells on your worksheet here.
00:51You're going to go Format, Conditional Formatting, and on the far right side, you can see this Conditional Formatting
00:58menu appears, and you can see that there's no selection for borders here. So long and short of it, at this time of this video
01:05recording, you cannot dynamically add borders in Google Sheet like in Excel using Conditional Formatting.
Comments