|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|
You can use Conditional Formatting to apply formats to selected cells that meet specific criteria based on values or formulas you specify.