Write any five conditions / formats /items that can be used for conditional
formatting in Ms-Excel?
Answers
Answered by
2
Answer:
Conditional formatting thus allows you to visually analyze your data, based on a large number of condition types,
Greater than, Less than, Between
Above / Below Average
Top / Bottom 10
Top / Bottom 10%
Duplicates / Uniques
Dates – Dynamic or a fix date range
Text containing
Apart from these in-built ones, you can create ‘n’ number of conditions using the ‘Use a formula’ option as explained in 1 example above.
Try to use IF, AND, OR, LEFT, RIGHT kind of functions within the ‘Use a formula’ option and create your own conditions.
Explanation:
Similar questions