Link to home
Start Free TrialLog in
Avatar of cfhasan1
cfhasan1Flag for United States of America

asked on

Change conditional formatting highlight specific reference

Highligh Gantt Chart based upon dates and category.
125-Maint-Analysis_Events_database-.xlsx
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

ok here is first comment

in your sheet drop down these are the categories
UTA
INSPECTION
DEPLOYMENT
AEF
EXERCISE
TRAINING
DEPLOYMENT
TRAINING
AEFs
CONSTRUCTION
FED TASKING
ST TASKING

However in the legend:
1. You don't hv all the list
2. Some of them are mis-typed or does not exist in the list

So what do you want to have all of them or only the one listed in legend highlighted in the respective colors ?
gowflow
Avatar of cfhasan1

ASKER

Only use the legend entries above
1. Meaning all the rest of the items if they are encountered then will not be colored right ?
2. What is FHP ?
3. for  CCIP EXERCISE/INSPECTION you have EXERCISE shall I replace it ? it is important to note that whatever will be written in Col G will have to match the formula you had put TRAININGS (I removed the 'S' or else it will not highlight. Unless we create a dropdown from the list in sheet dropdown therefore will build the formulas basis on the list and you cannot edit values in Col G or else they will not be colored so your choice.

Just specify me the use and I will suggest a best approach.
gowflow
1. Any blank or not listed item highlight a default gray.
2. FHP is a specific category
3. Replace with just CCIP and Drop-down list with ensure continuity
ok noted all this updated however I still do not understand this graph. Could you please explain it to me:

I take the row 18 it has TRAINING with dates 7/jan 15/jan and it highlight the following cells:
2 and 3 and from 10 to 18

Can you please explain the logic ??? and is this the desired output ??
gowflow
That's what I noticed. The logic is it should highlight 5-13.

I can't figure where I went wrong.
I'm sorry 5-15 should be highlighted
EXACTLY !!!! that is what I thought also but since you said that is what I expect then I did not worry but now I am not convinced this is why I asked I will look into it. I will be busy for the next couple of hours will look into this asap. Don't worry I do not accept but perfect on the dot work

gowflow
Thank you
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent work
Great glad I could help. Please feel free to post a link in here for any question you may need help with.
gowflow