Hello,
I have a requirement to do a 'horse blanket' which shows highlights of different business units activities across a fiscal year. I have the begin and end dates, and the duration calculated. I've been able to highlight all dates entered in the begin and end date columns but they're all highlighted in the same color. I would like to automatically highlight them with different colors based on the business unit to provide more of a distinguishing effect. I would also like to add the text from the "Mission" column to be in the highlighted date range. I'm unable to attach files to this post. When I select the attachments control, I get just a thin, narrow text box with no "browse to file" controls.
To highlight the cells I used information from this link: https colon slash slash www dot youtube dot com/watch?v=00s5efQWrgU
Would someone please help me with this? Thanks. Link for file is below:
https colon slash slash docs dot google dot com/spreadsheets/d/11nq5_yInlgLEwXKZAUPooI_0JVOLdMGmANyhVoamMTA/edit?usp=sharing
Bookmarks