• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unsure what formula i should be using

N

Nic351

New Member
After googling for days i am unsure of what formula i should use.
eg. Timeline / conditional formatting. Where u only need a Completed date.

If B2 has a completed date of a project.eg 13/07/2015
I want a highlighted cell in three years time(like a Gantt chart?).
If each column D1 =2016, E1=2017,F1 =2018 H1=2019

I do have the formula for the date but to add to columns unsure??
=DATE(YEAR(b2)+3,MONTH(b2)+0,DAY(b2)+0)

Thanks for the Help
 
Firstly, Welcome to the Chandoo.org Forums

Can you post a sample file

You also need to define more clearly what the problem is?

It sounds like you want to either setup a time line or highlight cells that are 3 years or more in the future.
 
Still not entirely sure what you want
If you select B2:G9
then goto the Home, Conditional Formatting Tab
select New Rule
select use a Formula
=AND(ISNUMBER(B2),B2>EDATE(TODAY(),36))
set the Format as you please

see attached file:
 

Attachments

Can you post a sample of a before and after in a worksheet
paste values and colors to highlight what you want
 
You must log in or register to reply here.
Back
Top