Highlight Cell

Hello, trying to use the conditional formatting.  In C24 i need yellow if in c5 there are the word "TS" located within that cell,  The cell contain mulitple data values, but if there is a "TS" in there then change the the color of C24 to yellow.  I need the exact same thing done for D6:Z6, and highlighting the cells D24;Z24 based on the corresponding cell.

Basically once i get the formula down for C24, do i have to manually type the formula in each cell for example D6, E6, F6 each would need each own formula, or is there a way to do it all at once.
sandramacAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NBVCCommented:
The conditional formula for C24 would be:

=SEARCH("TS",C5)

Then select D24:Z24 and use CF formula:

=SEARCH("TS",D24)

The D24 will adjust relatively for the rest of the cells in your selection.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sandramacAuthor Commented:
Thanks
0
NBVCCommented:
That second one should have been:

=SEARCH("TS",D6)
0
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

sandramacAuthor Commented:
Oh just caught something, it does not change if C5 has TSBC, it only looks for "TS"
0
sandramacAuthor Commented:
C5 should have changed to yellow since there is TS in it. How do I adjust for that
0
NBVCCommented:
It highlights fine for me.

Go back and look at the conditional formula and make sure there are no quotes around it... and that it is referencing the cell you are looking at.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.