which function can help to highlight the cells with red and green colour
Answers
Answer:
With conditional formatting, you can select one or more cells, and create rules (conditions) for when and how those cells are formatted. The conditions can be, based on the selected cell's contents, or based on the contents of another cell.
You can control the following formats:
Number format
Font, font style, and font colour (but not font size)
Fill colour and fill pattern
Border colour and border style (but not border thickness)
If the rules (conditions) that you specified are met, then the formatting is applied.
For example, you can set conditional formatting so that a cell turns red if its value is low, and turns green if its value is high.
Explanation:
It's may be help you
Pls mark as brainest answer
Pls follow me
sorry don't know the answer