is it possible to count the cell border lines? in a rectangular cell there are 4 border. If I color red on 3 border lines, is there a formula to show its 3?
is it possible to count the cell border lines? in a rectangular cell there are 4 border. If I color red on 3 border lines, is there a formula to show its 3?
Hi, welcome to the forum
Colors, fonts, borders etc are cosmetic formatting, not data. Excel formulas work on data, so there are no regular formulas that will do this for you - but perhaps somebody can put some VBA together to do this for 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks