| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying rules set on a range of cells
I have selected a range of cells in a row and created a rule to change text
color if conditions are met. I have multiple rows to which I wish to apply this same rule. However, when I try to copy this rule it just increases the range of cells that it affects. Methinks it may be due to Excel applying absolute references to the "Applies to" cells which cannot be removed. Is it possible to copy this rule to a different set of cells? If so, can you please tell me how? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying A Range of Cells to Another Worksheet | Excel Discussion (Misc queries) | |||
| Copying Conditional Formatting to range of cells | Excel Worksheet Functions | |||
| how do I set up a validation rules with two data rules | Excel Worksheet Functions | |||
| Problem copying formula to range of cells | Setting up and Configuration of Excel | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
