I have spreadsheets that I sort on a certain column but the range is a mix of not only data but cell formatting such as fill colours & cell borders.
Now while the cells with fill colours all goes well & the majority of cells have basic borders but some have larger colour borders and these borders do not move with the specific cells that they are around.
Is there a method of having such defined borders move with cells upon data sort?
Ron
Last edited by Mabocat; 09-25-2019 at 07:51 PM. Reason: spelling correction
Short answer, I would say no. You are applying formatting to the cell, so the formatting stays with the cell, but the cell contents move when you sort them.
If there is some logic to why the extra formatting is applied, we may be able to come up with some Conditional Formatting to help you?
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
Thank you.
The specific formatting is to highlight to users of the spreadsheet certain data & notes. It is interesting that fill info, a colour, moves with the cell data though.
Ron
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
OK, when I know how to attach a file & it gets done. so re-sort it using column A and see the cell K11 border does not follow the cell dataOriginally Posted by FDibbins
Ron
I think I found how to upload an attachment but now adding it to this thread ? but clicking on the attachment icon just gives me small box so I don't know how to select it?
all good so it seems once I previewed the thread
Ron
Can you see the attached? is this how you want it done? It is conditional formatting.
I couldnt do the thick red border, but if it is for visual purposes only maybe the same white font over a red background would do.
Thank you, that is what I read elsewhere about conditional formatting - yes for visual purposes only so i will do a different fill colour & font.
Ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks