It does this by popping up a message making sure that you're sure about the edit, and offers to not provide warnings for the next 5 minutes.Easily solve math calculations! Take a photo of any math problem, then get answers with detailed step-by-step explanations. You'll want a warning assuming that it's a personal use thing, so that it actually does what it's intended to do- prevent you from accidentally messing things up. The problem is that it by default protects every cell in the sheet, so many cells that you may not want protected will now be protected, but, since you can pick any number of ranges at once, it makes protecting larger sheets far quicker.Īfter telling it to set permissions, a message will pop up asking if you want it to only allow certain people to edit it, or prevent other people from editing it. However, if you select "Except Certain Cells", you can pick any number of ranges to be left unprotected. If you pick the sheet option, it will, by default, protect the entire sheet. You select the range the same way as any other range. However, it can only do one range at a time, so on larger sheets, not so much. This will protect anything within a single range, and not affect the rest of the sheet, so it's better for smaller sheets. Next we'll be adding in Sheet Protection to make sure that we don't unintentionally edit cells that we don't want to edit, such as section titles and formulas.įirst is a range. Now, the higher the amount left, the darker the green it will show as, and the further below zero, the darker the red it will show as. In this case, I chose -1,000 as the minimum, 0 as the middle, and 1,000 as the maximum. What you'll want to do is select a range that's a fair bit above and below your expected results, but only 2-3 times that. If the number is above or below the relative max or min, the color will simply show as the color selected for that end. ![]() After that, you'll need to select either end and the middle of a scale, as well as the colors in each of those places. The "Apply to Range" section is similar to how the earlier Data Validation worked. However, here we'll be using color scaling. Now, from here we can also set it to check a range of cells for specific or a range of entries and change the cell's text properties such as font styles, font type, font size, font color, background color, etc. We'll need to go to the format menu and select "Conditional Formatting". Next, we'll be using conditional formatting to give a quick and easy gauge of our costs vs our budget. We'll apply these conditions, whatever conditions we decide on, to every place we'll be entering data or a formula. ![]() Finally, we can have it display help text while showing a warning, which should be set up to tell you what's wrong with it. What I've shown here is a warning message so that you don't loose anything valid. ![]() Now, we can either set it to reject an invalid input, or display a warning message. So, we're just going to have it be between as large of a negative number as seems appropriate, and a positive number that is just as long. Now, for this specific purpose we just want to make sure that its a number. In this case, we will be using the number field. The dropdown menu allows you to pick what kind of criteria it is, such as a number within a range, a specific formula being included, etc. The second thing is your criteria type and specific. You can type in a new cell range if you don't like the listed one, or click on the icon of 4 cells in the right edge of the text field to select new ones. Whatever cells were selected when you open the Data Validation menu will currently be listed here. This dictates what parts of the sheet are affected by the Data Validation. This has a few different things you can adjust. It should bring up a popup menu titled "Data Validation".īasically, what this is going to do is allow you to set a set of criteria for certain cells that will display an error when certain things are entered into them, as seen in the bottom and middle right pictures for this step. ![]() To do this, go to the "Data" menu, and select "Data Validation". In smaller sheets this might not be needed, but it's a nice touch, and in larger sheets can become more necessary. This will warn you when you input a piece of data that is invalid.
0 Comments
Leave a Reply. |