cfhasan1
asked on
Change conditional formatting highlight specific reference
Highligh Gantt Chart based upon dates and category.
125-Maint-Analysis_Events_database-.xlsx
125-Maint-Analysis_Events_database-.xlsx
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
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
ASKER
1. Any blank or not listed item highlight a default gray.
ASKER
2. FHP is a specific category
3. Replace with just CCIP and Drop-down list with ensure continuity
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
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
ASKER
That's what I noticed. The logic is it should highlight 5-13.
I can't figure where I went wrong.
I can't figure where I went wrong.
ASKER
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
gowflow
ASKER
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
gowflow
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