Hi,
I'm trying to highlight the entire row with conditional formatting if I=1 and L=DL*.
So far I've tried
=COUNTIFS(I6:I10000="1",L6:L10000="DL*")
=COUNTIF($L6,"*DL*")
=AND($I6="1", $L6="DL*")
=AND($I6=1,$L6="DL*")
=(COUNTIF($I6="1")+COUNTIF($L6="DL*"))
=AND($L6=”DL*”;$I6=1)
And more, but nothing seems to work.
Any help appreciated.
How about like this...
Conditional Formatting
- Highlight applicable range >> A2:L200
- Home Tab >> Styles >> Conditional Formatting >> New Rule
- Select a Rule Type: Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =AND($I2=1,LEFT($L2,2)="DL")
- Format… [Number, Font, Border, Fill]
- OK >> OK
HTH
Regards, Jeff
to highlight the row , you need to fix the columns using $
BUT L=DL*.
does that mean if the cell text starts with DL - or contains DL and an asterix , as written DL*
select the range A1 to L10000
then use
= AND($I1=1,$L1="DL*")
now if a row contains in I = 1 and in L = DL* the whole row should highlight
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
DL* means there is a number directly after DL but the number always changes.
Neither of these suggestions have worked and @etaf my OP shows your suggestion already tried. Maybe I am missing something simple?
When I apply the conditions no rows or cells highlight.
How about attach a small sample worksheet? With what I posted works in my sample, but my sample may not be what you have.
jeffreybrown POST SHOULD work
is I a number 1 or text 1 ?
Workbook attached, its the orange rule in CF that I'm trying to get working.
what row had DL ?
What about...
=AND($I6=1,SEARCH("DL",$L6))
Legend, that seems to work
Would there be any need to use * after DL?
Good to know. Thanks for the feedback. We are happy to help.
No. Search is searching for the letters DL. It doesn't care what's after.Originally Posted by ~TaC~
The only drawback. If anything else was in column L that began with DL, but I can't think of any word that meets that criteria, but I am no English major.
I always like to try and work things out so I know for next time, but I've been trying for hours to do this without success.
Thanks for the help guys much appreciated.
Again, you are very welcome.
https://www.excelfunctions.net/excel...-function.html
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks