Conditional Formatting

Conditional formatting is a feature included in the popular spreadsheet creation programs Excel and Google Sheets. This feature automatically applies formatting, such as font color or bolding, to a cell when the data in that cell meets specific criteria. For example, in the image, the font color is automatically changed to red in all cells with negative values.

Using conditional formatting in Excel

To add conditional formatting to an Excel workbook, follow the steps below.

Open or create an Excel workbook.

Select the desired range of cells. You may also select the entire workbook using Ctrl+A.

On the Home tab, select the Conditional Formatting option, then select New Rule.

In the New Formatting Rule window, select the type of rule you want to create under Select a Rule Type.

Under Edit the Rule Description, select the desired Format Style, and select or enter the necessary criteria for the Rule Type and Format Style selected.

Click OK to save and apply the rule to the selected cells

Using conditional formatting in Google Sheets

To add conditional formatting to a Google Sheets workbook, follow the steps below.

Go to the Google Sheets website and open or create a workbook.

Select the desired range of cells. You may also select the entire workbook using Ctrl+A.

Select Format from the menu bar and click Conditional Formatting.

For a rule with only one format, select the Single color tab. For a rule that affects different values differently, select Color scale.

Under Format rules, select the rules you want the selected text to follow.

Under Formatting style, select how the affected text will be displayed.

Select the Done button to add the rule.

What is an Operating System? » Computer Shortcut Keys and their Functions

» Keyboard Function Keys » Computer Basics - Hardware - Software - Parts

Short Stories for Kids - Moral Stories – English Short Stories for Children - Moral Stories for Kids - Stories for Kids - Funny Story for Kids - Scary Stories for Kids - Really Funny Short Stories - Bedtime Stories
Proverb Stories
Powerful Motivational Quotes for Students » Success Quotes » English Short Stories for Kids

Cabin Crew Jobs & Career Advice » Secretary Job Description » Receptionist Job Description » Top 100 Interview Questions and Answers » How to Prepare for an Interview » How to Write a CV » How to Choose a Career » Computer Shortcut Keys and their Functions

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Computer Basics FAQ.

Army Jobs - Navy Jobs - Military Jobs

Scholarship 2024/25

Current Scholarships 2024/2025 - Fully Funded

Full Undergraduate Scholarships 2024/2025

Fully Funded Masters Scholarships 2024/25

PhD Scholarships for International Students - Fully Funded!

Funding Opportunities for Journalists 2024/2025

Funding for NGOs 2024/2025

Funding for Artists 2024/2025

Funding for Entrepreneurs 2024/2025

✅Over 4500 Current Fully Funded Scholarships for International Students

✅ Undergraduate Scholarships 2024

✅ Masters Scholarships 2024

✅ PhD Scholarships 2024 Click Here!

Free Scholarship Newsletter --- E-mail Address

First Name

Then Don't worry — your e-mail address is totally secure. I promise to use it only to send you Advance Africa Newsletter.