Conditional Formatting - which range to use in "applies to"?

Hi,

I have data in A1 to Z50 and want to apply conditional formatting to each of these rows.

Some rows in this range require one set of rules for formatting and other rows will have another set of rules applied.

I’ll create each of the two conditional formatting schemes in a row and will then paste-format the format to the applicable rows.

Something I’m struggling with is the “applies to” option when creating the conditional formatting rules.

If, say, A1:Z10, A13:Z25, A33:Z42 and A44:Z50 should have one set of conditional formatting rules, and the other areas in A1 to Z50 will have the other set of conditional formatting rules, what range should “applies to” refer to when creating the two sets of rule?

Thanks!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

You've deleted the text of your question, but luckily I read it before that!

Don't worry too much about the 'applies to' if you're going to be 'paste-formatting' the rules. Select your first range, do the CF for it, then 'paste-format' to the other ranges - Excel will automatically deal with the 'applies to'.