West Bengal Electronics Industry Corporation Limited
Highlight interesting cells, emphasize unusual values, and visualize data using Data Bars, Color Scales,
and Icon Sets based on criteria.
Basic Conditional Formatting:-
1. Format the Salary more than 16000?
Select the Salary without heading → Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on Greater than → Format cells that contain are Greater Than: 16000 → Custom Format: Choose
the Font Color and Fill Color → OK → OK
2. Format the Salary less than 14000?
Select the Salary without heading → Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on Less than → Format cells that contain are Less Than: 14000 → Custom Format: Choose the Font
Color and Fill Color → OK → OK
3. Format the DA more than 1500 but DA less than 1700?
Select the DA without heading → Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on Between → Format cells that contain are between: 1500, 1700 → Custom Format: Choose the
Font Color and Fill Color → OK → OK
4. Format the DA equal to 2000?
Select the DA without heading → Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on Equal to → Format cells that contain are between: 2000 → Custom Format: Choose the Font
Color and Fill Color → OK → OK
5. Format the Saltlake Location?
Select the Location without heading → Click on Conditional Formatting → Click on Highlight Cells Rules 🡪
Click on Text That Contains → Format cells that contain are text: Saltlake → Custom Format: Choose the
Font Color and Fill Color → OK → OK
6. Format the DOJ which has been Date Today?
Select the DOJ without heading → Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on A Date Occurring → Format cells that contain a date occurring: Today → Custom Format:
Choose the Font Color and Fill Color → OK → OK
7. Format the DOJ which has been Date Last Month?
West Bengal Electronics Industry Corporation Limited
Select the DOJ without heading → Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on A Date Occurring → Format cells that contain a date occurring: Last Month → Custom Format:
Choose the Font Color and Fill Color → OK → OK
8. Format the Duplicate Values on Plant?
Select the Plant without heading →Click on Conditional Formatting → Click on Highlight Cells Rules →
Click on Duplicate values → Format cells that contain: Automatically Selected Duplicate Values →
Custom Format: Choose the Font Color and Fill Color → OK → OK
9. Format the Unique Values on Location?
Select the Location without heading → Click on Conditional Formatting → Click on Highlight Cells Rules 🡪
Click on Duplicate values Dropdown → Click on Unique→ Format cells that contain: Automatically
Selected Unique Values →Custom Format: Choose the Font Color and Fill Color → OK → OK
10.Format the TOP 2 numbers of HRA?
Select the HRA without heading →Click on Conditional Formatting → Click on Top/Bottom Rules→ Click
on Top 10 Items (It’s by default) →Write their 2 (as per your requires) → Custom Format: Choose the
Font Color and Fill Color → OK → OK
11.Format the Bottom 3 numbers of Gross?
Select the Gross without heading →Click on Conditional Formatting → Click on Top/Bottom Rules→
Click on Top 10 Items (It’s by default) →Format values that rank in the: Write their 3 (as per your
requires) 🡪 Custom Format: Choose the Font Color and Fill Color → OK → OK
12.Format the Above Average of TA?
Select the TA without heading → Click on Conditional Formatting → Click on Top/Bottom Rules→ Click
on Above Average → Custom Format: Choose the Font Color and Fill Color → OK → OK
13.Format the Below Average of Bonus?
Select the Bonus without heading → Click on Conditional Formatting → Click on Top/Bottom Rules→
Click on Below Average → Custom Format: Choose the Font Color and Fill Color → OK → OK
14.Format the Commissions using by DATA BARS?
Select the Commissions without heading →Click on Conditional Formatting → Click on Data Bars→
Custom Format: Choose the Font Color and Fill Color → OK → OK
15.Format the PF using by color scale?
West Bengal Electronics Industry Corporation Limited
Select the PF without heading → Click on Conditional Formatting → Click on COLOR SCALE→ Custom
Format: Choose the Font Color and Fill Color → OK → OK
16.Format the Increment using by ICON SETS?
Select the Increment without heading → Click on Conditional Formatting → Click on Icon Sets→ Custom
Format: Choose the Font Color and Fill Color → OK → OK
