Conditional Formatting commands apply formats to cells when the cells meet the criteria.
Added by Eric L.
Step 1
Step 2: Go to the "Home" tab on the Excel ribbon. Step 3: Click on the "Conditional Formatting" button in the "Styles" group. Step 4: Choose the type of conditional formatting you want to apply, such as "Highlight Cells Rules" or "Top/Bottom Rules". Step 5: Show more…
Show all steps
Your feedback will help us improve your experience
Sri K and 65 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Conditional formatting is a useful way to visually highlight certain data. Describe the two basic Conditional Formatting commands: Highlight Cells Rules and Top/Bottom Rules, and give an example of how each might be used.
Sri K.
how can you format a range of cell with decimal value
Chandra J.
Choose the correct option: The "highlight cells with bars" option is selected when you want to highlight all cells satisfying a given condition (Rules/Data).
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD