![]() ![]() Then select Cell Value in the first drop down, less than in the second drop down, and enter the following formula: When the New Formatting Rule window appears, select the “Format only cells that contain” rule type. When the Conditional Formatting Rules Manager window appears, click on the “New Rule” button to enter the first condition.Ĥ. Then in the styles group, click on the Conditional Formatting drop-down and select Manage Rules.ģ. ![]() Select the Home tab in the toolbar at the top of the screen.Ģ. ![]() ![]() You’re also welcome to download the workbook to practice.ġ. Below is a demonstration of how this can be done. This is achievable with conditional formatting. For example, if you have expiry dates for stock in a spreadsheet, it’s possible to highlight the stock that has expired as well as the stock that will expire within 30 days. From Excel 2010, there’s a way to automatically highlight upcoming and past due dates. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |