What is conditional formatting and when would you use it?
What will be an ideal response?
Conditional formatting is a set of rules that determine when formatting is applied to a value. The rules can compare one field value to another or compare a field value to a set number. If the rule is true, then the formatting is applied and it is not, then no formatting is applied. Conditional formatting is useful to highlight data in a report based on certain criteria.
You might also like to view...
If you forget the password to a protected worksheet, you can contact Microsoft to get a replacement password to unprotect it
Indicate whether the statement is true or false
When you use computing resources of another computer over a network, you are using ________
Fill in the blank(s) with the appropriate word(s).
The constructor without parameters is called the ____.
A. helper function B. default constructor C. destructor D. default destructor
____________________ can ensure that a value is the correct data type or that it falls within an acceptable range.
Fill in the blank(s) with the appropriate word(s).