How to Make excel highlight a date as it arrives

3 posts · originally from https://geek.digit.in/community/threads/how-to-make-excel-highlight-a-date-as-it-arrives.88088/

Hi,

Im trying to get excel to highlight a date 1 day before it arrives, i
have dates in a column ( Eg : Column I, from row 2 ), am preparing a follow up sheet in excel where i have to keep track of the customers to visit on coming days, thats the purpose of this formula, i will be greatful for your help

thanks
-keves-

Considering that you have name of the customer in B3 cell and the date to meet that customer in C3 cell.
1. Select the B3 cell and choose 'Format -> Conditional formatting'
2. Select 'Formula Is' in the 'Condition1' field
3. Input '=$B$3-1=TODAY()' in the text box
4. Click the 'Format' button and choose a font style

Thanks , after googling a lot..i just come across this tutorial to do the same, i never know that i can make like this, really useful one

*exceltips.vitalnews.com/Pages/T002664_Conditional_Formatting_Based_on_Date_Proximity.html