#Conditional formatting excel 2016 mac expired dates serial number

The Excel TODAY function returns the serial number of the current date. The Excel WEEKDAY function returns a integer value representing the day fo the week for a given Excel date and the value is range from 1 to 7.The syntax of the WEEKDAY function is as below:=WEEKDAY (serial_number,)… You should see that the entire rows which contain the current day have been highlighted. Click Fill tab, select on color that you want to use. #4 click Format button, and the Format Cells dialog will open. Note: the Cell A2 is the first cell of your selected range. To highlight row if date is in the current month, use the following formula: 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.