LinkBack URL
About LinkBacks
I want an entire row to strikethrough any text and highlight the row in my table if a cell in my notes column says "removed." I hope what I am asking makes sense.
Thank you in advance for any help.
I want an entire row to strikethrough any text and highlight the row in my table if a cell in my notes column says "removed." I hope what I am asking makes sense.
Thank you in advance for any help.
Select the area that you want conditionally formatted (let's say that is A2:Z100) > Highlight A2:Z100 > Conditional Formatting > New Rule > Use a formula
Let's say that the notes column is in column N. Use this as your CF formula:
=COUNTIF($N2,"*removed*")
Format > Fill color of your choice > Check the Strikethrough box > OK > OK
Which cell says 'removed'? Is it on the same row?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
how can i get this to work for the whole table do I have to redo it for each row?
yes aliGW it is in the same row
Did you follow 63falcondude's directions?
If you select the whole range 1st, it will be added to the "Applies To" box. If you didnt, you can still click on the Applies To" box, click the dropdown on the right, then highlight the range - OR just type the range in
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
yea I was skipping that step thanks for pointing it out and thanks for all the help.
Good stuff, the devil is in the details lol.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks