In this tutorial you will learn how to use conditional cell format in excel. Microsoft excel providing powerful features of formatting of cells, sheets and fonts etc. So conditional format can be used in result sheet for representation of results in effective way. You can use it in the result sheet of students, result sheet of games and in data sheet of store. You can fill cell with different colors on different conditions.

conditional cell format in excel example:-

For use conditional format in microsoft excel create sheet of student marks like as sheet which is given below.

sheet-of-students

You want to change color of cell on specific condition. If student pass then cell of student column is of green color and if student fails then color be red. So visit style panel of home menu.

style-panel-of-home-menu

From style panel visit conditional formatting option by clicking on it.

option-named-as-conditional-formatting

Now click on color scales menu and select the color scale red yellow and green for the cell.

conditional cell format in excel

When color scale selected then visit  option named as manage rules.

manage-rules

After selection of manage rules a dialog box appeared like as following.

conditional cell format in excel

Now click on edit rule button and after click appearance like this.

edit-formatting-rule-dialog-box

Select a rule type as format all cells based on their values. From edit rule description select in minimum the formula.

slection-of-options-for-format-formula

By selection of formula and color red for minimum. Also for maximum type formula and color green and format style 2-color scale.

formatting-selection

Now put the values so according to values the color be the change according to conditions.

edit-value-type

Press OK button and select highlight cell rule between.

So now set equal to PASS and color green from custom color.

equal-to-edited

After pressing OK button so then applied on cell.

gree-cell-on-pass

Also select equal to FAIL then fill cell with red color and copy editing of cell on next cell.

Now enter record on next student and copy editing on this cell.

entering-new-record

Hence used that conditional format cell excel.

 

Please follow and like us:

ali hiader

Leave a Reply

Your email address will not be published. Required fields are marked *