Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My conditional formatting applies to cells (see row numbers):
=$B$41 =$B$42 When I insert 10 rows between row 41 and 42, the condition now applies to cells as follows: =$B$41:$B$51 1. Is there a way that the condtions will not be copied to rows 42 to 51? Or, the condition will apply only to each cell, i.e." =$B$41 =$B$42 =$B$43 etc. to =$B$51 Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Condtional Formatting | Excel Worksheet Functions | |||
Condtional Formatting | Excel Worksheet Functions | |||
Wildcard In Condtional Formatting. | Excel Discussion (Misc queries) | |||
Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
Condtional formatting | Excel Worksheet Functions |