When you use the Today() function, Excel will automatically determine the current date and compare the data accordingly. The complete formula should look like this: After that, click on the Format ...