| How to Apply Conditional Formatting in Excel Posted: 24 Jan 2018 04:00 PM PST This wikiHow teaches you how to add conditional formatting to a Microsoft Excel spreadsheet on both Windows and Mac computers. Conditional formatting will highlight cells that contain data matching the parameters that you set for the formatting. - Open your document in Excel. Double-click the Excel spreadsheet that you want to format.
- If you haven't yet created your document, open a new blank spreadsheet in Excel and enter your data before continuing.
- Select your data. Click and drag your mouse from the top-left cell in your data group to the bottom-right cell in your data group. Your data should now be highlighted.
- Click the tab. It's at the top of the Excel window. This is where you'll find the Conditional Formatting option.
- Click . You'll find this in the "Styles" section of the Home toolbar. Clicking it prompts a drop-down menu to appear.
- Click . It's near the bottom of the drop-down menu. Doing so opens the Conditional Formatting window.
- Select a rule type. In the "Select a Rule Type" section, click one of the following rules:
- Format all cells based on their values - Applies conditional formatting to every cell in your data. This is the best option for creating a visual gradient when organizing data by average, etc.
- Format only cells that contain - Applies conditional formatting only to cells containing your specified parameters (e.g., numbers higher than 100).
- Format only top or bottom ranked values - Applies conditional formatting to the specified top- or bottom-ranked number (or percentage) of cells.
- Format only values that are above or below average - Applies conditional formatting to cells falling above or below the average as calculated by Excel.
- Format only unique or duplicate values - Applies conditional formatting to either unique or duplicate values.
- Use a formula to determine which cells to format - Applies conditional formatting to cells based on a formula that you have to enter.
- Edit your rule. This step will vary based on the rule that you selected:
- Format all cells based on their values - Select a "Minimum" and a "Maximum" value using the drop-down boxes. You can also change the color used for each value in the "Color" drop-down box.
- Format only cells that contain - Select the type of cell that you want to format, then select other rules in the drop-down boxes that appear based on your choice.
- Format only top or bottom ranked values - Select either Top or Bottom, then enter a number of cells to format. You can also enter a percentage number and check the "% of the selected range" box.
- Format only values that are above or below average - Select an above or below average value.
- Format only unique or duplicate values - Select either duplicate or unique in the drop-down box.
- Use a formula to determine which cells to format - Enter your preferred formula in the text box.
- Click . It's in the lower-right side of the window. A new window will open.
- Click the tab. This tab is in the upper-right side of the new window.
- Select a color. Click a color that you want to use for the conditional formatting. This is the color that cells matching your formatting parameters will display.
- Err on the side of light colors (e.g., yellow, light-green, light-blue), as darker colors tend to obscure the text in the cells—especially if you print the document later.
- Click . It's at the bottom of the window. Doing so closes the "Format" window.
- Click to apply the formatting. You should see any cells matching your formatting criteria become highlighted with your chosen color.
- If you decide that you want to erase the formatting and start over, click Conditional Formatting, select Clear Rules, and click Clear Rules from Entire Sheet.
- Save your spreadsheet. Click File, then click Save to save your changes, or press (or on a Mac). If you want to save this document as a new document, do the following:
- Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type the document's name into the "File name" text box, and click Save.
- Mac - Click File, click Save As..., enter the document's name in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save.
- The Conditional Formatting drop-down menu has several shortcut options (e.g., Highlight Cells Rules) that you can use to quickly format your data.
- One practical use of conditional formatting is using it to identify cells containing negative numbers in a budget (or zeroes in a store inventory sheet, etc.) so that you don't have to hunt manually for discrepancies.
- Avoid formatting colors or options that make the cells to which they're applied difficult to read.
EditRelated wikiHows |
| How to Survive a Fast River Current Posted: 24 Jan 2018 08:00 AM PST Swimming in lakes, rivers and streams can be safe at designated swimming areas that are protected by lifeguards. However, drowning is the fifth leading cause of unintentional injury and death in the U.S. [1] More skills and energy are required for natural water environments because of cold water and air temperatures, currents, waves and other conditions—and these conditions can change due to weather. Knowing how to survive and get out of a river current can save your life - and others. EditAvoiding Getting Stuck - Know the risks of swimming in rivers. Swimming is a hazardous activity, even for people who are strong swimmers. Areas which are not monitored or designated for swimming are much more so. Even though swimming in a river on a hot day is a great pleasure, very often there are not the safeguards one would find at a pool or a life guard protected beach.
- Humans do not swim well. Humans are not well-designed for swimming. An Olympic-class athlete can swim about 4.5 m.p.h, or about 2 meters a second. The average swimmer is much less than that. It does not take much of a current to overcome a swimmer's abilities.
- Most drownings take place in outdoor water bodies.[2]
- Know the dangers of currents. Rivers are natural features, which are often inconstant and change from day to day, season to season. Rivers may have very fast currents, and getting caught in rushing water can be very dangerous. Also, it is not always easy or obvious that a waterway has a strong current. Check for:
- Weather. If it has been raining heavily, chances are good that the water level is up.
- "Flash flood" prone areas. Some rivers are noted for suddenly flooding due to mountain rain or other geological conditions.
- Obvious fast-moving currents, waves and rapids, even in shallow water.
- Hazards, such as dams, underwater obstacles, or rocks or debris moving on the surface or along the bottom of the water.
- Try to determine how fast the water is moving. Throwing objects, especially buoyant objects, such as wood, a stick, soda bottle or a ball into the middle of the river will begin to give you an idea of the speed.
- Remember, there is sometimes a current on the surface, and an undercurrent. The speed on the surface will not give you an indication of the undercurrent.
- Just because the surface is moving slow does not mean it is safe.
- Know the abilities of those going with you, including swimming abilities and level of supervision required. Be sure to provide appropriate supervision.
- Ensure everyone learns to swim well by enrolling them in age-appropriate learn-to-swim courses. However, this does not mean people are protected from mishaps. In the case of small children, it can actually make them over-confident of abilities.
- Have weak swimmers wear U.S. Coast Guard-approved life jackets whenever they are in, on or around water. Do not rely upon water wings or inflatable toys; they can enable swimmers to go beyond their ability or suddenly deflate, which could lead to a drowning situation.
- Practice normal swim safety.
- Always swim with a buddy. Never swim alone, or with someone who cannot swim.
- Always enter unknown or shallow water cautiously, feet first.
- Be safe for diving. Diving areas should be at least 9 feet deep with no underwater obstacles. Rivers typically rise and lower in height, and the riverbed may shift--it is usually not possible to know if it is truly safe for diving.
- Do not jump from a great height, such as a tree, ledge or bridge.
- Be careful when standing to prevent being knocked over by currents or waves.
- Do not use alcohol and/or drugs before or while swimming, diving or supervising swimmers.
EditGetting Out of a Current - Do not panic or flail. As with a riptide, panicking and flailing your limbs can push you deeper into the water. Try to take even breaths and remain calm. Hyperventilating can cause you to under. Breathing in can cause you to be more buoyant, helping to reduce sinking.
- Aim to swim diagonally toward the shoreline. Do not try to swim straight towards the shore, as you will fight with the current too much and waste energy. Try to swim at a 45° angle; you will move down further than if you were swimming without a current.
- Do not try to swim upstream. It will not work. If you are swept away you are already in current too strong for you to overcome that way.
- Float down on your back, with your feet pointed downstream, and your head positioned upstream. This is the way most experts recommend. [3] This way, your head is protected. Your legs and feet will take any of the damage from rocks and debris. The top half of your feet should be poking out of the water, flexed, and your head should be above water as well. Look downstream and keep calm, as well as breathing with the flow of the water, to keep from swallowing too much water. When you come up on a calmer area, flip over and swim diagonally toward shore, with the flow of the current.
- Call for help. Make as much noise and draw as much attention as you can With this, would-be rescuers can not only keep you above the water, but pull you back in.
- It's helpful to bring a life buoy (a.k.a a ring buoy). This way, you can both stay above the water, and get pulled back in.
- Get medical help. Chances are good that you will be absolutely fine, but an incident like this needs a medical examination. Usually a 911 (emergency) call will summon paramedics and EMT.
EditSources and Citations
Cite error: <ref> tags exist, but no <references/> tag was found
|
| How to Inspect Element on Chrome Posted: 24 Jan 2018 12:00 AM PST This wikiHow teaches you how to inspect the HTML source code of a visual element on any web page on Google Chrome, using a computer. Edit10-Second Summary 1. Open any website on Chrome.
2. Right-click an element on the page.
3. Select Inspect.
- Open Google Chrome on your computer. The Chrome icon looks like a colored ball with a blue dot at the center. You can find it in your Applications folder on a Mac, or on your Start menu on Windows.
- Click the three vertical dots icon. This button is located next to the address bar in the upper-right corner of your browser window. It will open a drop-down menu.
- Hover over on the drop-down menu. A sub-menu will pop up.
- Click on the More Tools sub-menu. This will open the Inspector column on the right-hand side of your browser window.
- Alternatively, you can open the Inspector with a keyboard shortcut. This shortcut is on Mac, and on Windows.
- Hover over an element on the Inspector column. Moving your mouse to an element or a line in Inspector will highlight the selected element on the web page.
- Right-click an element you want to inspect on any web page. Your right-click menu will pop up in a drop-down box.
- Select on the drop-down menu. This will scroll the Inspector column up or down to the selected element, and highlight its source code.
- You don't have to manually open the Inspector column to do this. Selecting Inspect on the right-click menu will automatically open the Inspector.
|
No comments:
Post a Comment