I'm trying to hightlight M1 if any cell in range of D34:J42 contains "CTR" or "MTL".
I'm trying to hightlight M1 if any cell in range of D34:J42 contains "CTR" or "MTL".
Apply this in Conditional formatting of cell M1:
Please Login or Register to view this content.
Quang PT
Thank you bebo021999, works perfect
another way
select the range you want to apply to (M1)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=COUNTIF(D34:J42,"*CTR*")+COUNTIF(D34:J42,"*MTL*")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks