How can I highlight one cell based on a matching cell being highlighted?

[Mandanae]

I have a spreadsheet with 2 rows of Company's. I need to highlight the 2 column depending on if the 1 column is highlighted or not.
Example.xlsx

In my attachment, I need the company's in column E to automatically highlight depending on whether or not they are highlight in column A.

Also, I'm not sure if I attached the file correctly.

Any help would be greatly appreciated. Thanks

[6StringJazzer]

Welcome to the Forum Mandanae!

The highlight in column A is conditional formatting based on the content in column C, so you can use the same logic for column E. See attached.

Please Login or Register  to view this content.

[Mandanae]

Thank you so much, I finally got it to work.

[6StringJazzer]

Didn't the file I provided work?

[Mandanae]

Yes, it did. It was more me than anything. Sometimes I get confused with the formulas. I'm learning.

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.