| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format - Outline Border
You're welcome. Thanks for the feedback!
Biff "Sam via OfficeKB.com" <u4102@uwe wrote in message news:717e84636cbff@uwe... Hi Biff, Brilliant! Very much appreciated. Cheers, Sam T. Valko wrote: Ok, if we don't have to be concerned with empty cells we can reduce the formula to: =OR(AND(MOD(ROW(),2)=0,$B2=E2),AND(MOD(ROW(),2)= 1,$B2=OFFSET(E2,-1,,))) And it will handle multiple duplicates. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200704/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - Frame cells with Outline Border | Excel Discussion (Misc queries) | |||
| Conditional Format - Outline Border | Excel Worksheet Functions | |||
| Export to outline format | Excel Worksheet Functions | |||
| Outline format in Excel | Excel Discussion (Misc queries) | |||
| only last cell on page to have bottom border (cell area outline) | Excel Worksheet Functions | |||
Threaded Mode
