View the step-by-step solution to:

PLEASE RESPOND Conditional formatting allows a user to create rules to automatically format cells to emphasize certain areas of a data range.

PLEASE RESPOND


Conditional formatting allows a user to create rules to automatically format cells to emphasize certain areas of a data range. For example, you can use conditional formatting to change the color or highlight certain numbers such as the highest number or lowest number. You can also use conditional formatting to compare different values or show repeated values. To change a condition after creating a conditioning formatting rule, you can simply modify the rule using the Rules manager instead of creating a new rule. To d this you select the cells that contain the conditional formatting, click on the conditional formatting button in the styles group and then select manage rules. You can then select the rule you want to edit from the conditional formatting rules manager dialog box, click edit rule and modify the setting.

 

Class, what does your reading say about conditional formatting? What can you find the Internet? Thoughts? Experiences?

Top Answer

Conditional formatting is used to highlight data based on condition. We can... View the full answer

1.PNG

2.PNG

3.PNG

4.PNG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online