to apply the rule to several rows, first select the whole range you want the rule to apply to, then create the rule with the correct formula. If you want the rule to aplly to an extended range, you have to edit the rule, you cannot copy the format; under conditional formatting-manage rules-edit rule-change the range for this rule. to apply the formula to all rows in range, the formula should look like: =$A9="p" ,(notice that before row number there is no $) . If you put the $ sign in front of the row number, the format will be applied only to row 9. Look at the sample attached. you can check this thread for similar problems:
https://www.msofficeforums.com/excel...ence-data.html