MS EXCEL : Conditionally format your worksheet

MS EXCEL : Conditionally format your worksheet

If you want to monitor your data by highlighting
certain conditions, the conditional Excel format
The feature can help you. For example, if your company
offers a bonus every time sales exceed 150,000
dollars, you can have Excel Excel cells that contain
sales figures provided the value is greater than
150,000 dollars. You can also highlight Excel
a cell when the input is smaller, between or equal
to a specified value. Use Excel conditional
Format function to monitor text, dates, duplicate
values, the upper N, the upper N percent, the lower N,
the lower N percent, higher than average values, or
below average values.

The changes affect the data with conditional formatting. Yes later
a change, a cell no longer meets the condition, Excel
Remove highlighting. Yes, after a change, a cell
meets the condition, Excel adds highlighted. Your
determine exactly what the condition is and what
It should happen if a cell meets the condition. Standing out
provides you with a list of formats from which
Choose, and you can also create a custom format.

CONDITIONAL FORMAT

1 Click and drag to select the data.
do you want to monitor
2 Click the Start tab.
3 Click Conditional Formatting.
A menu appears.
4 Click to select a menu option.
A submenu appears.
5 Click to select a menu option.

A dialog box appears.

Note: this example uses
Larger than.
6 Enter your criteria.
7 Click here and select the
format you want to apply.
You can choose to create a
custom format
8 Click OK.
Excel highlights all data
That meets your criteria.

DATA BARS

1 Repeat steps 1 to 3
listed under Conditional
Format.
l this is the one selected
data.
A menu appears.
2 Click Data Bars.
A submenu appears.
3 Click on the color data bar
do you want to use

Excel applies the data bars to the cells that
selected.

Did you know

Excel offers you several colors to choose from
since when you add data bars to your worksheet.
You can select another color. Click on the Start tab
and then click on Conditional Formatting in the styles
group. A menu appears. Click on Data Bars and then
Click More rules. The New Format Rule dialog box
the box Use the Bar Color field to select a new one appears
color. Click OK

Did you know

You can use color scales to format data conditionally.
Color scales use color gradations. For example, yes
use Excel yellow and green color scale, yellow
It represents lower values ​​and green, higher values. TO
apply a color scale, select the cells to which
you want to apply the scale, click on the Start tab, click on
Conditional formatting, click on Color scales and then
Click on the color scale you want to apply.