![]() ![]() If you want to highlight the row that If the date in that row is equal to the current day or is in the current week or month, you can do the following steps: Highlight Row if Date is in Current Day/Week/Month ![]() #4 you should notice that the current date has been highlighted. And if you want to highlight the cell if date is in the current month, just choose This Month from the first drop down list box. Note: if you want to highlight the cell if date is in the current week, just choose This Week option from the first drop down list box. #3 if you want to highlight the current day, then select Today option from the first drop down list box in the A Date Occurring dialog box, then choose one color that you want to fill the cell in the second drop down list box. And the A Date Occurring dialog will appear. #2 go to HOME tab, click Conditional Formatting command under Styles group, and click Highlight Cells Rules menu from the drop down menu list, then select A Date Occurring sub menu. #1 select the range of cells that you want to highlight date. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |