As mentioned above, we want to know the months in which sales was above 5000 in NewYork. ![]() Alternatively, you can also use shortcut key : Alt + H + Lģ.Click on the dropdown and you shall see various options.Ĥ.When you will hover your mouse on any of the options, you will find other sub options.ĥ.You can go ahead with any formatting option which you feel is appropriate for your data. In the example below, we have selected the cells C2:C13 as we want to know the months in which sales was above 5000 in NewYork.Ģ.You will find the conditional formatting option at the right hand side of the home tab. How to Use Conditional Formatting?ġ.Select the data that needs the formatting. To save you from facing a similar situation we bring to an article on conditional formatting in Excel that will help you to highlight the right things as per your requirements. Not highlighting the important things cannot only cost you some marks but also some important projects at times. Why? No, the teacher was not partial but the thing was, that one student had highlighted the important points whereas the other had simply written them. ![]() ![]() Two similar answer sheets, two same answers but one student gets more marks than the other.
0 Comments
Leave a Reply. |