Highlight rows in different colorss based on text cell value

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

Originally Posted by frnorke

...When I select the attachments control, I get just a thin, narrow text box ...

Do not try to use the Paperclip icon (Attachments button), as this does not work on this forum.

Instead, you should use this approach:

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hope this helps.

Pete

Thanks Pete. I'll give that a try...

Here's the attachment for my question.

Hi JeteMc. That is exactly what I'm looking for. Thank you so very much for your help!