Conditional Formatting in Excel is a way to give a certain format in certain circumstances. For example normally used to provide color automatically at specific data. To more easily admin gave an example: If the student receives a grade of less than 6 on a subject then the format will be colored red automatically.
Immediately, we make an example of the data:
Then block / select the entire data value >>> >> click Conditional Formatting will appear under the fig sprt
Here there are a lot of options we'll discuss one by one
Because we cover less than we choose Highlight Cells Rules >>> >>> Less Than >> will appear
Because its value is less than six interchangeable red value of the type 6
It will receive the results of a value less than 6 will be red
Thank you good luck
Tag :
Office Skill
0 Komentar untuk "MS Excel Automatic Color Give Conditional Formating"