ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Border (https://www.excelbanter.com/excel-discussion-misc-queries/183198-border.html)

Neil Pearce

Border
 
Good afternoon all,

Is it possible for a given range of cells to place a border around cells
that are of a certain colour, but only if the cell next to the border is of a
different colour?

e.g. Range A1:J10, place borders to the sides of the red cells that share a
boundary with a non-red cell?

i.e. place an outline around a shape in the specified range

I assume this will require some sort of bespoke code?


Thanks in advance.

Kind regards,

Neil




All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com