Strikethrough once a task is complete

[HarvestChurch]

Good afternoon
I have created a Time Management Matrix - it has 4 quadrants that create a square and they have headings urgent & Important, Urgent & Not Important etc.
The appropriate quadrant is automatically populated from a list of tasks - I set a formula to do this
The task list has 3 columns, Urgent and Important and Status - these are dropdowns

The bit I am struggling with is when I select Completed status I want to strike through the text in 1 quadrant and in the list of tasks, so its very easy to see that the task has been completed. I have tried using Conditional Formatting>Create a new rule>formula

So I have selected all 4 quadrants and used a formula =$k$5="Completed" but then it strikes through everything is the same row and not just in 1 quadrant -
Or if I only select 1 quadrant is strikethrough random items

what am I doing wrong?

Is conditional formatting the way to go

Or should I use VBA?

Can anyone help me please with some very simple and basic instructions

Thank you

 

[Joe4]

Welcome to the Board!

Without seeing the exact layout of all your data (especially exactly where all 4 quadrants are located on your sheet), I think maybe you need 4 separate Conditonal Formatting rules, one for each quadrant.

 

[HarvestChurch]

Welcome to the Board!

Without seeing the exact layout of all your data (especially exactly where all 4 quadrants are located on your sheet), I think maybe you need 4 separate Conditonal Formatting rules, one for each quadrant.

Welcome to the Board!

Without seeing the exact layout of all your data (especially exactly where all 4 quadrants are located on your sheet), I think maybe you need 4 separate Conditonal Formatting rules, one for each quadrant.

 

[HarvestChurch]

Hi Joe4
Thank you for your prompt response. I am not sure how I can send you the spreadsheet. I have tried to download XL2BB but the error message that I cannot open in protected view and don't know how to resolve that
Does the picture help?
Thanks
Karen

​