![]() In order to make this visualization “dynamic,” I make references to cells that contain the =TODAY() Function. However, this will only work if you are using Excel 2007 or Excel 2010. Here, I demonstrate how she can do this using Conditional Formatting Rules. A third color when it has been over 90 days since the last contact with a client.A different color when the time frame is between 60 and 90 days.One background color to cells where it has been less than 60 days since last contact.She is monitoring the frequency of contact with her clients and she wants Excel to automatically apply: One of my viewers wants to learn how to “dynamically” color-code cells that contain dates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |