If the content of a cell does not satisfy the condition, the formatting of the cell remains unchanged. 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. |