![]() Set the formatting condition as «Format cells that are GREATER THAN:» 10, and choose «Green Fill Dark Green Text». In the right one, select «Light Red Fill Dark Red Text». «Highlight Cells Rules» - «Greater Than». We need the numbers that are greater than 6 to be highlighted with red. ![]() ![]() Conditional formatting – several conditions In the newly-opened window, you can see which rule is applied to which range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |