Question

Explain the detail process of conditional formatting with example.​

Answer 1

Answer:

Conditional formatting is used to highlight the important or required entries:

example: You want to color, Bold, Italic, or Highlight cells which has more that 5

if A4> 5 than color by red, blue, or green whatever

Follow the following step for better understanding:

Problem Statement: Highlight all the values which are greater than 2500 in Unit Sold by Green