# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am curious if there is a way to input a start date and have excel notify monthly. I am working with monthly check ins and would like to know who needs a report. I saw that I could type in a date and have it notify me of that certain date or prior to, but I didn't see reoccurring.
Solved by A. H. in 44 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/04/2018 - 07:27
Hi…Welcome to Got It Pro
Excelchat Expert 23/04/2018 - 07:27
In what form, are you looking the notification to happen?
User 23/04/2018 - 07:28
if it could highlight the cell, that would work
Excelchat Expert 23/04/2018 - 07:28
ok
Excelchat Expert 23/04/2018 - 07:29
and will notification be on a specific day of the month?
Excelchat Expert 23/04/2018 - 07:29
say every 1st of the month
User 23/04/2018 - 07:30
yeah. for example, if check ins were implemented today, they would be required the 23rd of every month for the next 6 months
Excelchat Expert 23/04/2018 - 07:31
ok, 23rd of every month
User 23/04/2018 - 07:32
yes, that works
Excelchat Expert 23/04/2018 - 07:32
ok got you
Excelchat Expert 23/04/2018 - 07:35
Excelchat Expert 23/04/2018 - 07:36
cell B2 is highlighted based on cell A1
Excelchat Expert 23/04/2018 - 07:36
just to tell you how it works, i have entered 24th Jan, 2018 in cell A3 and it highlights cll B3
Excelchat Expert 23/04/2018 - 07:37
Is that what you wanted?
Excelchat Expert 23/04/2018 - 07:37
and this will notify every month yb highligting the cell, when the date arrives
Excelchat Expert 23/04/2018 - 07:39
Hi...are you there?
User 23/04/2018 - 07:40
When I tried to change the date in A1, just to test it, it just repeated the date in the B1
Excelchat Expert 23/04/2018 - 07:40
what date you are putting in A1?
User 23/04/2018 - 07:40
oh actualy it just did 3 months way
User 23/04/2018 - 07:41
I tried to type in 5/24/2018, to see if it would change it to 6/24/2018
User 23/04/2018 - 07:41
and it changed it to 4/24/2018
User 23/04/2018 - 07:42
what I was hoping for was if I typed in a date, it would auto fill for one month away and highlight when that date (the future date) came up.
Excelchat Expert 23/04/2018 - 07:43
ok ...so if you putting a future date, then I will need to change the formula
Excelchat Expert 23/04/2018 - 07:43
let me change it
User 23/04/2018 - 07:43
I hope that makes sense
Excelchat Expert 23/04/2018 - 07:44
yes, it does
Excelchat Expert 23/04/2018 - 07:45
ok so it should be 24th june in cell B1
Excelchat Expert 23/04/2018 - 07:45
now when do you want that highlighted?
User 23/04/2018 - 07:46
either the day of or one day prior. doesn't matter
Excelchat Expert 23/04/2018 - 07:48
ok
Excelchat Expert 23/04/2018 - 07:50
something like this
User 23/04/2018 - 07:51
yes! that works!
Excelchat Expert 23/04/2018 - 07:52
and it will highlight only when the date is either today or a day prior
Excelchat Expert 23/04/2018 - 07:52
Excelchat Expert 23/04/2018 - 07:53
highlight is done through conditional formatting formula
User 23/04/2018 - 07:54
and if I wanted to make happen for another row I would just change all the A1's to whatever cell I wanted?
Excelchat Expert 23/04/2018 - 07:55
yes, you will just need to drag down the formula in cell B1
Excelchat Expert 23/04/2018 - 07:55
and then you can put your date in any row in column A
User 23/04/2018 - 07:55
how do I drag it down?
Excelchat Expert 23/04/2018 - 07:57
when you click on cell B1, and hover to the lower right corner, you will see a + symbol appear, that's when you can drag it down and you formula will be copied
Excelchat Expert 23/04/2018 - 07:58
Alternatively, you can just copy cell B1 and paste it below
Excelchat Expert 23/04/2018 - 07:59
but since you want to copy the formula down, in order for the conditional format to also copy, we will need to change the conditional format formula to take cell relative reference instead of the absolute reference.
Excelchat Expert 23/04/2018 - 07:59
Are you familiar with conditional formatting with formulas?
User 23/04/2018 - 07:59
i am not
Excelchat Expert 23/04/2018 - 07:59
Should I guide you as how to do that?
User 23/04/2018 - 08:00
Excelchat Expert 23/04/2018 - 08:00
ok perfect
Excelchat Expert 23/04/2018 - 08:00
Excelchat Expert 23/04/2018 - 08:01
And then form Home tab, go to Conditional Formatting
Excelchat Expert 23/04/2018 - 08:01
pull down conditional formatting menu and you will find Manage rules, Click on that
Excelchat Expert 23/04/2018 - 08:02
oh..i think you are clicking on this google sheet
Excelchat Expert 23/04/2018 - 08:02
User 23/04/2018 - 08:02
will do
Excelchat Expert 23/04/2018 - 08:03
So do you Conditional formatting rule manager dialog box opened now?
User 23/04/2018 - 08:03
yep!
Excelchat Expert 23/04/2018 - 08:03
you will see the conditional formatting rule I just applied
Excelchat Expert 23/04/2018 - 08:04
So click on Edit rule
Excelchat Expert 23/04/2018 - 08:04
Now you will see a formula which is driving this condition
Excelchat Expert 23/04/2018 - 08:04
=OR(\$B\$1=TODAY(),TODAY()-\$B\$1=1)
Excelchat Expert 23/04/2018 - 08:05
\$B\$1 -----as you notice it has a \$ sign before column and row, which means its an absolute reference
Excelchat Expert 23/04/2018 - 08:06
and this will always consider cell B1 for conditional format, even if you copy this format to the cell below
Excelchat Expert 23/04/2018 - 08:06
Now we need it to refer cell B2, if we want conditional format for cell B2
Excelchat Expert 23/04/2018 - 08:07
So instead of \$B\$1, you will have to change it to \$B1
Excelchat Expert 23/04/2018 - 08:07
Excelchat Expert 23/04/2018 - 08:07
=OR(\$B1=TODAY(),TODAY()-\$B1=1)
Excelchat Expert 23/04/2018 - 08:07
Are you with me?
User 23/04/2018 - 08:07
yes
Excelchat Expert 23/04/2018 - 08:08
ok..replace that formula with the one I just gave you
Excelchat Expert 23/04/2018 - 08:08
and click OK
Excelchat Expert 23/04/2018 - 08:08
Now you can copy cell B1, to anywhere below and it will copy cell formula as well as conditional formatting appropriately
User 23/04/2018 - 08:09
okay!
Excelchat Expert 23/04/2018 - 08:10
User 23/04/2018 - 08:11
yes!
Excelchat Expert 23/04/2018 - 08:11
Please do give me a good feedback for my service.
User 23/04/2018 - 08:11
thanl you
Excelchat Expert 23/04/2018 - 08:11
Thanks for your time. Please do come back for any new question. Have a great day ahead!
User 23/04/2018 - 08:11
you too!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.