Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel Highlight question

0
                Current Date 22-04-2017           22-04-2017 03-05-2017 14-05-2017 25-05-2017 05-06-2017 23-04-2017 04-05-2017 15-05-2017 26-05-2017 06-06-2017 24-04-2017 05-05-2017 16-05-2017 27-05-2017 07-06-2017 25-04-2017 06-05-2017 17-05-2017 28-05-2017 08-06-2017 26-04-2017 07-05-2017 18-05-2017 29-05-2017 09-06-2017 27-04-2017 08-05-2017 19-05-2017 30-05-2017 10-06-2017 28-04-2017 09-05-2017 20-05-2017 31-05-2017 11-06-2017 29-04-2017 10-05-2017 21-05-2017 01-06-2017 12-06-2017 30-04-2017 11-05-2017 22-05-2017 02-06-2017 13-06-2017 01-05-2017 12-05-2017 23-05-2017 03-06-2017 14-06-2017 02-05-2017 13-05-2017 24-05-2017 04-06-2017 15-06-2017          

Highlight Dates in the Next 30 Days

Answer
Discuss

Discussion

I am just as lazy as you are, lol:
Variatus (rep: 4889) Oct 5, '17 at 3:49 am
Dude.... until you provide a sample workbook or a detailed explanation of what you need, all I'm gonna say is "conditional formatting + date functions"
don (rep: 1989) Oct 5, '17 at 5:32 am
Add to Discussion

Answers

1

Use conditional formatting or Create an IF formula (perhaps in cell below or adjacent) that would put "w/in 30days" if <=30 days or a Blank cell (or 'Not 30D").

Really, how hard could it be to  copy and/or paste a sample, if you really want assistance?

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login