0
You've selected a range of cells in a worksheet You now want to format each cell in the range that contains a value higher thatn 65000 Use conditional formatting to format the relevant cells with?
Wiki User
∙ 14y ago
Steps: 1. Click Conditional Formatting and select Greater Than... from the Highlight Cells Rules menu 2. Type $65,000 in the Format cells that are GREATER THAN text box and click OK
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you undo conditional formatting in Excel?
There is a delete option when you open the Conditional Formatting option. You could also use the Format Painter to paste formatting from a cell with no conditional formatting onto the cell that has.
How can you format a worksheet in excel so the column headings will show on all pages?
First, open the relevant worksheet. Right click on the sheet tab and select the "Select all sheets" option. Input your titles on the first sheet and these will then be applied to every sheet. Don't forget to save the work!
What zone type contains only SOA name server and glue records for the relevant zone?
stub zone
How do you do a survey on a website?
Use formatting. Group similar questions to keep your survey logical and focused. ... Ask often. ... Be brief. ... Ease into it. ... Stick to specifics. ... Clarify, clarify, clarify. ... Keep it relevant. ... Avoid yes/no questions.
Why the glossary is useful to community interpreters?
a glossary contains explanations of concepts relevant to a certain field of study or action. In this sense, the term is related to the notion
What companies are named after hades?
There are a few, below link contains relevant information.
Is Answers.com compatible with Windows 7?
Answers.com is a website, so what operating system you're running shouldn't be relevant. What browser you're using may be. I use Google Chrome and occasionally have formatting glitches... usually not recognizing paragraphs... but it still basically works.
What type of line spacing should be used after the main title?
After the main title, it is common to use double line spacing. However, the specific line spacing may vary depending on the formatting guidelines provided by the relevant style guide or publication.
What are the importance of having a hyperlink in a worksheet?
They can be very useful in working with Powerpoint. You can use them to jump to other slides, to jump to other slide shows, to jump to other documents, to jump to websites etc. You can attach them to buttons or text.
How can keyword tools be of use to students?
Keyword tools can be used by students to organize information and then select relevant sources to further identify families, core keywords and helpers. Using a keyword worksheet can help with the organization and further assist with the volume and value of the information.
Why is apple iPhone important?
the apples is so important because it is very nutritious and contains plenty of vitamins that your body needs.
Why did the declaration of independence become part of the American creed?
The Declaration of Independence became part of the American creed as it was the basis of founding the nation. It contains all the relevant principles of the nation.
