CONDITIONAL FORMAT IN EXCEL

aaet classes

CONDITIONAL FORMAT IN EXCEL

Conditional Formatting

MS Excel 2010 Conditional Formatting aaetclasses.in feature enables you to format a range of values
so that values outside certain limits,are automatically formatted.

Choose Home Tab » Style group » Conditional Formatting drop down.

Various conditional formatting options

Highlight Cells Rules: It opens a continuation menu with various options for
defining formatting rules that highlight the cells in the cell selection that
contain certain values, text, or dates, or that have values greater or less than a
particular value, or that fall within a certain ranges of values.

Suppose you want to find cell with Amount 0 and Mark them as red.Choose Range of
cell » Home Tab » Conditional Formatting Drop-down » Highlight Cell Rules » Equal
To

After Clicking ok the cells with value zero are marked as red.

Top/Bottom Rules: It opens a continuation menu with various options for
defining formatting rules that highlight the top and bottom values, percentages,
and above and below average values in the cell selection.

Suppose you want to highlight top 10% rows you can do this with these Top/Bottom
rules

Data Bars: It opens a palette with different color data bars that you can apply to
the cell selection to indicate their values relative to each other by clicking the
data bar thumbnail.

With this conditional Formatting data Bars will appear in each cell.

Color Scales: It opens a palette with different three- and two-colored scales that
you can apply to the cell selection to indicate their values relative to each other
by clicking the color scale thumbnail.

See below screenshot with Color Scales conditional formatting applied.

Icon Sets: It opens a palette with different sets of icons that you can apply to the
cell selection to indicate their values relative to each other by clicking the icon
set.

See below screenshot with Icon Sets conditional formatting applied.

New Rule: It opens the New Formatting Rule dialog box, where you define a
custom conditional formatting rule to apply to the cell selection.

Clear Rules: It opens a continuation menu, where you can remove conditional
formatting rules for the cell selection by clicking the Selected Cells option, for
the entire worksheet by clicking the Entire Sheet option, or for just the current
data table by clicking the This Table option.

Manage Rules: It opens the Conditional Formatting Rules Manager dialog box,
where you edit and delete particular rules as well as adjust their rule precedence
by moving them up or down in the Rules list box. aaetclasses.in

Contact us:-

Website:- www.aaetclasses.in

Facebook Page :- aaetcomputerclasses

Instagram:- @aaeteducation

Telegram:- Online Computer Course

Blog:- https://aaetclasses.in/blog/

YouTube Channel :- aaetclasses

Tumblr:-https://www.tumblr.com

linkedin:-https://www.linkedin.com/

twitter:-https://twitter.com

Is Matter Around Us Pure Class-9 Chapter-2:-.youtube.com

Chemical Reactions and Equations Class-10 Science Chapter-1:- https://www.youtube.com