The conditional formatting rule that can be used in highlighting sales value than more than $5000 as regards this question is greater than.
- Conditional formatting can be regarded as feature in spreadsheet applications , which helps when there is a need to apply specific formatting to cells that meet certain criteria.
- In the case, of formatting rule for figures greater than $5,000, the the Greater Than sign is used to achieve this.
- The greater-than sign is helps in denoting an inequality between two values
- Other uses of formatting rule are to :
- highlight
- Emphasize
differentiate among data as well as information stored in a spreadsheet
Therefore, conditional format helps in changing the appearance of cells
learn more at:https://brainly.com/question/16014701?referrer=searchResults
