I have tried and can't seem to get this to work. I am trying to conditionally format the cells in columns U & X based on the partial text value of the cell in column B of the same row.
For example, If B12 contains the text 10/15/15-mc T16, I want to change the fill and text color in U12 & X12 based on the partial text (*T16*) in B12.
I have searched the forum and have tried a few different formulas that worked for others, but they do not seem to work for this case.
Try
Select U1
Conditional Formatting
New Rule
Use a formula to determine...
=(ISNUMBER(SEARCH(B12,"T16"))=TRUE)
Format as required
Use Format painter (paintbrush icon) to copy to other cells
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Use this formula as condition format:
=ISNUMBER(SEARCH("T16",B12))
Quang PT
@Special-K
=(ISNUMBER(SEARCH(B12,"T16"))=TRUE)
Ha ha, not checked yet for sure. Also "=TRUE" is not needed.
Special-K; Thanks much, that got me on the right track.
bebo021999; Thanks to you as well, the switching of the formula criteria did the trick
Working great
Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks