I need help writing a macro that compares text in a cell to the one below it to apply formating
something along the lines of
Please Login or Register to view this content.
I need help writing a macro that compares text in a cell to the one below it to apply formating
something along the lines of
Please Login or Register to view this content.
Last edited by Leith Ross; 06-18-2019 at 02:55 PM.
Offset(row,column), so if you want below it is 1,0 not 0,1
However, this method avoids un-necessary selects:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Would this work for a range that changed due to yes count? It's a Boolean comparison
5 - 1
5 - 2
5 - 3
5 - 4
4 - 3
4 - 2
4 - 1
etc.
Only looking at the text in the A column?
And would there be a way to make it apply the formatting from A1:A6
Sorry for not including all of this in my initial post.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Attachment 628751
Attachment 628752
It currently looks like this.
Please Login or Register to view this content.
Last edited by Leith Ross; 06-18-2019 at 02:56 PM.
Hmm... the attachments didn't work. Did you use the instructions in my previous post?
I added the attachtment
Sorry im new to this, I uploaded the attachment like you stated above, it showed in the current attachment section I closed the tab now I can't see the file I attached.
Sorry strpurdu, I still can't find any attachments. In your private message you said something about columns to the right? Yet a post here says A1:A6 which is rows 1 to 6. I'm a bit confused that's why I wanted a file that illustrates the desired result better.
Did you click the "choose file button", and then after picking the file, click the "upload" button?
Sorry my private message was right, It needs to format the cell itself and 8 cells to the right. So for example it'll apply formatting around A3:I3 Depending on the text in A3 and how it compares to A4. Hope that helps explain it a little. The code you sent works, I just need it to apply the same action to the 8 cells to the right of the one it's checking
Attached Test Attached Test Attached Test Attached Test Attached Test
The number of Values in A can change, and sorry the text isn't the same as in before and after but you get the point right?
Ok I see... how about this:
Please Login or Register to view this content.
It's good but it seems to mess up the table at the bottom, is there anyway to make it stop when cell value is empty.
Thank you so much for all your help
I see a bit of odd lines still near the bottom, due to conditional formatting, but code wise I believe this should do it:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks