what is conditional formatting? Give any four examples
Answers
Answer:
Conditional formatting is a fantastic way to quickly visualize data in a spreadsheet. With conditional formatting, you can do things like highlight dates in the next 30 days, flag data entry problems, highlight rows that contain top customers, show duplicates, and more.For example, using the "Equal to" preset, it's easy to highlight cells equal to "apple".But what if you want to highlight cells equal to "apple" or "kiwi" or "lime"? Sure, you can create a rule for each value, but that's a lot of trouble. Instead, you can simply use one rule based on a formula with the OR function:A rule to highlight x, y, or zHere's the result of the rule applied to the range B4:F8 in this spreadsheet:Conditional formatting with the OR functionHere's the exact formula used:=OR(B4="apple",B4="kiwi",B4="lime")
Answer:
Conditional formatting is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria. For example the following rules are used to highlight cells in the conditional_format.py example: worksheet...