is there anyway to highlight values in a range of cells, based on start dates of a project?
for example:
Start Date 01/01/12
Project A: has dollars budgeted on it for 02/15/12, then 03/15/12, and 04/15/12.
What I would want to do is highlight the cells that have those dollars on them if...
is there an easier way to get this info copied?
i guess my problem is that, they aren't just one cell space between them, some have multiple some have just one, some have none. is there a way to copy this information into teach cell faster than doing it one by one?
14151ABC PROJECT 14151AB...
if i have a set of projects with an expected start date - im trying to compare to see if these projects are still budgeting dollars after their start date.
i just want to pull something back - via true/false saying.
Project A - 5/1/12 Jan-12 $10 Feb-12 $10 Mar-12 $10 Apr-12 $10 May-12...