![]() ![]() Magikarp starts with "M", Lapras with "L", Vaporeon with "V", and Jolteon with "J". ![]() Now, the cells with text values later in the alphabet than "Gyarados" will be highlighted in yellow: Select the appearance option "Yellow Fill with Dark Yellow Text" from the dropdown menu.Gyarados, Lapras and Vaporeon have HP values greater than 65, so they are hightlighted. Now, the cells with values greater than "65" will be highlighted in green: Select the appearance option "Green Fill with Dark Green Text" from the dropdown menu.This will open a dialog box where you can specify the value and the appearance option. Select the Highlight Cell Rules from the drop-down menu.Click on the Conditional Formatting icon in the ribbon, from Home menu."Greater Than." Hightlight Cell Rule, step by step: It can be a a few cells, a single column, a single row, or a combination of multiple cells, rows and colums. You can choose any range for where the Highlight Cell Rule should apply. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |