How to Make excel highlight a date as it arrives

Status
Not open for further replies.
K

keves2002

Guest
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-
 

PcEnthu

Linux Learner
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
 
Status
Not open for further replies.
Top Bottom