Conditional Formatting

You can use Conditional Formatting to apply formats to selected cells that meet specific criteria based on values or formulas you specify.

a. First select the Cells or Range Of Cells that you want to apply Conditional Format and then Select Format - Conditional Formatting

b. Then click the operator you want to use to set the condition on the selected cell range (Ex : Cell Value is Less than or Equal to 5000)

c. Select the format elements you want to apply with conditional formatting. You can apply only one conditional format to a cell at a time.

d. After giving all the conditions and formats Click Ok Note : You can give maximum three Conditional Formats to a Selected Cell Range


Post a Comment