Re: SUM CELL BORDERS? (and by colour too?)

Thanks for advice/warning Jim,

But to persevere...

The duplication of the borders is good as for the model of a building
skirtings and paint will have to be appplied to both sides of the wall. Not
so good though for calculating the actual length of internal partitions/walls!

Is it possilbe to tell each cell in a column to look only at the right side
border and sum at the bottom. Then tell each cell in a row to count only the
bottom border and sum at the side?

"Jim Cone" wrote:


My recommendation is avoid "calculating" colored borders in your model.
Trying to use conditionally formatted borders could cause you to change your occupation. <g>

Even using "regular" colored borders could cause grief.
Borders between cells are common to both cells (except when they aren't).
Excel, however, does attempt to keep track of the "owner" cell for the border.
Unless all cells with borders were isolated from other cells, I would find another way.

You might want to play with the free "Determine Colors" add-in available as
a direct download from my Website. It is at the bottom of the products page.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Neil Pearce"
wrote in message
Dear all,
I'm a quantity surveyor and have been creating a cost model for a generic
building. Using the formulas below and conditonal formatting I have managed
to create a range of building shapes that are visually displayed within a
workbook. The building's area and perimeter are automatically calculated.
This is very useful for costing external walls, floor & ceiling finishes,
roof, floor slab, foundations etc.

=CellColorIndex(Cell)
=CountByColor(Range,CellColorIndex,FALSE)

I would now like to expand my model and be able to draw onto my plan
internal partitons/walls by using the border options of the cells.

Is there a way to count/sum the cell border lines like the coloured cells
were counted above above? Further is there a way to count those border lines
based on their colour therby enabling differing wall make-ups to be portrayed
and calculated?
Thanking-you in advance,
Neil

.

Relevant Pages

  • Re: background shading for even/odd table rows visible when printed?
    ... since you can use them for even rows only - odd rows can ... borders between rows, for example, set borders for cells suitably. ... I started using the even/odd shading before I was able to get ...
    (comp.infosystems.www.authoring.stylesheets)
  • Re: Can one cell hold multiple check boxes (and then sort based off e.
    ... Use separate cells, if you want them to appear grouped then ... use borders to encompass several cells. ... Some notes on sorting in Excel ... check boxes within one cell? ...
    (microsoft.public.excel.misc)
  • Re: Conditional format disaster in 2007
    ... In cells E14:I14 I inserted respectively Yes, Yes, Yes, Part, No. ... If E$14 = "Part" Borders yes, ... In cells E10:E10 I set conditional formats: ... "Peter T" wrote: ...
    (microsoft.public.excel.programming)
  • Re: Excel wont print the gridlines
    ... I remembered colored cells. ... gridlines so they are just ignored.. ... Try removing all color within cells, and removing all borders ... Select all cells Ctrl+A (or in Excel 2003 Ctrl+Shift+SpaceBar ...
    (microsoft.public.excel.setup)
  • Re: Excel wont print the gridlines
    ... I remembered colored cells. ... gridlines so they are just ignored.. ... Try removing all color within cells, and removing all borders ... Select all cells Ctrl+A (or in Excel 2003 Ctrl+Shift+SpaceBar ...
    (microsoft.public.excel.setup)