To make a long story short, I am creating database to manage scientific grants. Each type of grant has its own tab with all required information such as when it starts and stops.
I am using these dates to create a gantt chart and conditional formatting for color coding of the different grants.
Everything was fine until I try to import data from excel file: one excel file contains also tabs for each type of grant i.e. internship, congres, courses...
If I import the data concerning the internship, I can see in my gantt chart the color code for the congres and/or courses, although there is no date written in the corresponding date fields in FMP file.
FYI I have tried 2 different methods for the conditional formatting. All type of grants in one field or separate field and formatting for each grant. It happens in both cases.
If I enter manually these information for example in the internship tab, I do not have this problem and only the internship dates will be displayed on my chart.
I could enter everything manually but what the point then...
Did you encounter this problem? Do you think it is a misconception of my database/gantt chart or a bug?
You have an example pic of what I get. Hope it'll help you to understand my trouble here.