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


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: 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)
  • Re: Aligning Gridlines at 45 degrees (Orientation)
    ... You can't change the gridlines, ... What you can change is the borders. ... Select a row of 7 or 8 cells, ... But the text of all the columns in the first row is normal orientation. ...
    (microsoft.public.excel.newusers)