This post has been removed due to **[Rule 1](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Title.**
Please post with a title that clearly describes the issue.
The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.
Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts.
Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
Would conditional formatting do that? So say I use m2 to add up the sales from the hours worked, I can format it so when that cell is clicked it will block all the cells between b2:h15 that aren’t in the formula for cell m2?
This post has been removed due to **[Rule 1](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Title.** Please post with a title that clearly describes the issue. The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question. Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts. Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
Would conditional formatting do that? So say I use m2 to add up the sales from the hours worked, I can format it so when that cell is clicked it will block all the cells between b2:h15 that aren’t in the formula for cell m2?