![]() The condition being that you have placed Y in the cell which cues the box to turn green automatically. ![]() Then when you send out their card you can place a Y in the birthday card sent column and that cell will turn green letting you know at a glance that you have sent their card. You could build a conditional formatting rule in your customer spreadsheet to shade the customer’s birthday cell when the date is ten days from the current date. One example of conditional formatting might include wanting to keep track of customers’ birthdays so that you can send them a card. So let’s take a look at a few examples of conditional formatting available within Microsoft Excel. ![]() ![]() It provides a way to improve the appearance and increase the functionality of your spreadsheets as you’re working based on the conditions you have created. At some point, you may have found yourself asking, “What is conditional formatting?” Conditional formatting means that you can change or add visual cues based on a specified set of rules. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |