Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Cell Formatting
I am looking to setup borders within the range of active cells, meaning
if there is data in the furthest right column and data in the furthest down row, then to fill all cells encompassed in that intersection with a certain border scheme. The range will change per each report, so I need a dynamic range figured. I am also looking for code where the row will fill with background color, not the entire row only the cells that have data in them. And again, the ranges will fluctate so a simple macro with the range selected will not be beneficial. Thanks for your help, let me know if questions. ~schaapiee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) | |||
xls worksheet formatting a single cell | Excel Discussion (Misc queries) |