I am trying to make a Plan vs. Actual graph by using IF function both in cells & conditional formatting menu.I have a particular problem.Please see the narration below.
For e.g. my planned activity starts on 31-Aug-2010 and it takes 7 days to complete.The planned area shall be highlighted till 6-Sep-2010.But I'm not able to write the function in conditional formatting as both dates are from different months.
Please also see the attached file.
Hope to see your replies soon.
Abhisheik
Bookmarks