5. Tutorial of Microsoft Excel:

(1) What is Microsoft Excel and its installation.
(2) How to create & save a file Microsoft Excel.
(3) How to make a password protected Microsoft Excel file.
(4) How to select Cells/ Text.
(5) How to font change.
(6) How to Font size change.
(7) How to Font color change.
(8) How to make a text bold (B), Italic (I), Underline (U).
(9) How to Merge cells.
(10) How to cut, copy & paste cells/ text.
(11) How to align content with Left, Right, Center align, Top, Middle or Bottom align.
(12) How to Draw Cell border.
(13) How to change cells background color.
(14) How to cells background color, font, border change with condition (Conditional Formatting).
(15) How to use Data Validation to input fixed text in cells.
(16) How to hide or unhide rows and columns.
(17) How to apply filter.
(18) How to Page setup.
(19) How to print page.
(20) How to mimic a watermark or place background image.
Formulas and Functions
(1) Use of Sum & AutoSum.
(2) Use of Average function.
(3) How to Divided two value.
(4) How to Multiply two value.
(5) How to use Count formula.
(6) How to use COUNTIFS formula.
(7) How to use MAX formula.
(8) How to use MIN formula.
(9) How to use RANK formula.
(10) How to use IF formula.
(11) How to use SUMIFS formula.
(12) How to use LOOKUP formula.
Graph
(1) How to make a Column Graph.
(2) How to make a Line Graph.
(3) How to make a Line Graph with two or more series.
(4) How to make a Pie Graph.
(5) How to make a Combo Graph with secondary axis.
(14) How to cells background color, font, border change with condition (Conditional Formatting) in Microsoft Excel.

Select the all cell which background/ fill color you want to change with condition. From HOME tab in Styles section click to the Conditional Formatting & select your require condition.



Example-1: Highlight cells less than value:


Condition:

Highlight cells background/ fill color & font color change if the cells value is less than 150.



(i) Select the all cell which background/ fill color you want to change with condition. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules.

(ii) Click to New Rule. Than click to Format only cells that contain. In Edit the The Rule Description, Format only cells with section, select into box 1-Cell Value, box 2-less than, box-3 write 150. So the condition is Highlight cells background/ fill color & font color change if the cells value is less than 150. Than click to Format.

(iii) From Font section select Font style Italic & color Yellow. From Fill section select color Red. Click OK, click OK & click OK to Apply.

Result:

 The value under 150 is now highlighted by the background/fill color Red & font color change to yellow.



** To delete the rule/ condition select the all cell. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules. Select the rule & click to Delete Rule. Than click to OK.




See description with screenshot & Video


Description with screenshot:

Condition:

Highlight cells background/ fill color & font color change if the cells value is less than 150.

 


conditional formatting

(i) Select the all cell which background/ fill color you want to change with condition. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules.




(ii) Click to New Rule. Than click to Format only cells that contain. In Edit the The Rule Description, Format only cells with section, select into box 1-Cell Value, box 2-less than, box-3 write 150. Highlight cells background/ fill color & font color change if the cells value is less than 150. Than click to Format.


conditional formatting


conditional formatting


(iii) From Font section select Font style Italic & color Yellow. From Fill section select color Red. Click OK, click OK & click OK to Apply.

conditional formatting


conditional formatting

Result:

The value under 150 is now highlighted by the background/fill color Red & font color change to yellow. (See below picture).


conditional formatting

** To delete the rule/ condition select the all cell. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules. Select the rule & click to Delete Rule. Than click to OK.

conditional formatting



Example-2: Highlight cells if the cells contain Specific Text:


Condition:

Highlight cells background/ fill color if the cells contain text "Mango".



(i) Select the all cell which background/ fill color you want to change with condition. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules.

(ii) Click to New Rule. Than click to Format only cells that contain. In Edit the The Rule Description, Format only cells with section, select into box 1-Specific Text, box 2-containing, box-3 write Mango. So the condition is Highlight cells background/ fill color if the cells contain text "Mango". Than click to Format.

(iii) From Fill section select color Yellow . Click OK, click OK & click OK to Apply.

Result:

All cell background/ fill color change to yellow which contain text "Mango".



** To delete the rule/ condition select the all cell. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules. Select the rule & click to Delete Rule. Than click to OK.



See description with screenshot & Video

Description with screenshot:

Condition:

Highlight cells background/ fill color if the cells contain text "Mango".

 


conditional formatting
(i) Select the all cell which background/ fill color you want to change with condition. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules.


conditional formatting

(ii) Click to New Rule. Than click to Format only cells that contain. In Edit the The Rule Description, Format only cells with section, select into box 1-Specific Text, box 2-containing, box-3 write Mango. So the condition is Highlight cells background/ fill color if the cells contain text "Mango". Than click to Format.


conditional formatting


conditional formatting


(iii) From Fill section select color Yellow . Click OK, click OK & click OK to Apply.

conditional formatting


Result:

All cell background/ fill color change to yellow which contain text "Mango".

(See below picture).


conditional formatting

** To delete the rule/ condition select the all cell. From HOME tab in Styles section click to the Conditional Formatting, click to Manage Rules. Select the rule & click to Delete Rule. Than click to OK.

conditional formatting










Video:

Highlight cells less than value & Highlight cells if the cells contain Specific Text (Conditional Formatting) in Microsoft Excel: