![]() ![]() the green color to all the cells that satisfy the condition. ![]() ![]() Excel checks each cell in the range to determine whether the condition you specified, i.e., total sales of the person >= $2500 is satisfied.Įxcel applies the format you chose, i.e. You can set the condition as total sales of the person >= $2500 and specify a color code green. In a range containing the sales figures of the past quarter for a set of salespersons, you can highlight those cells representing who have met the defined target, say, $2500. The cells that meet the specified conditions would be formatted as you have defined. You have to specify formatting for a cell range based on the contents of the cell range. In Microsoft Excel, you can use Conditional Formatting for data visualization. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |