[go: up one dir, main page]
Scribd
Upload
8 views6 pages

Conditional Formatting

The document provides instructions on applying and clearing Conditional Formatting in Excel, detailing steps to access the feature through the Home Tab. It lists various types of Conditional Formatting, including Highlight Cell Rules and Custom Formulas, and explains how to use the Conditional Formatting Rules Manager. Additionally, it includes examples of custom formulas for highlighting errors, hiding zero values, and formatting alternate rows and columns.

Uploaded by

irfanmolla5a
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views6 pages

Conditional Formatting

The document provides instructions on applying and clearing Conditional Formatting in Excel, detailing steps to access the feature through the Home Tab. It lists various types of Conditional Formatting, including Highlight Cell Rules and Custom Formulas, and explains how to use the Conditional Formatting Rules Manager. Additionally, it includes examples of custom formulas for highlighting errors, hiding zero values, and formatting alternate rows and columns.

Uploaded by

irfanmolla5a
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 6

Conditional Formatting

1. How to apply Conditional Formatting -


Ans: Select Cells →Home Tab→ Conditional Formatting from Styles
group → Choose Formatting Condition → Choose Fomatting Style→ok

3
2. Clearing Conditional Formatting -
Ans: Select Cells →Home Tab→ Conditional Formatting → Clear Rules
→ Clear Rules from Selected Cells / Entire Cells.

Types of Conditonal Format -


1. Highlight Cell Rules 2. Top / Bottom Rules -

3. Data Bars
4. Color Scales 5. Icon Sets

6. Custom Formula & Advance Formatting Mode (More Rule)


Formula Exp : $B5=$G$3
Product List= Product Name Cell
Conditional Formatting Rules Manager -

*From This Dialog Box we can – Edit Condition/Rule, Delete Rules.

Excel Cell Reference –


More Custom Formula – Conditional formatting
1. Highlight Error/Blanks – A1 = 1st Cell of Selected Range

=OR(ISBLANK(A1),ISERROR(A1))

Process-
Select Range (Where you want to apply Conditional Formatting) → Home
tab→ Conditional formatting→ New Rule→ Use Formula to Determine……→ Input
the Custom Formula → Change color Format→ ok.

2. Hide Cell Data – 0 (Zero) Value


=E2=0

Result
3. Highlight Every Other Column & Other Row –
i. Highlight alternate even rows: =ISEVEN(ROW())
ii. Highlight alternate odd rows: =ISODD(ROW())
iii. Highlight every 3rd row: =MOD(ROW(),3)=0

=ISEVEN(ROW())

=MOD(ROW(),3)=0

You might also like