Dec 31 2021 03:26 AM - edited Jan 01 2022 05:19 AM
Dear Network,
I have prepared a Task Prioritization Matrix, I haven't been able to make a conditional formatting which can "Strikethrough" for the completed task: I need your help for at:
when the task is marked as "Completed" in Sheet1, Column E, so the task must be strikethrough in Sheet2! column D or F. It is important that the corresponding task is strikethrough independent of the task order in sheet 1.
- The excel contains 2 sheets, 1) data and 2) 4 quad matrix that displays the importance and urgency.
- Sheet 1! is conditioned upon [yes & No] furthermore the conditioned upon whether the task is completed or not.
- I have tried: =Sheet1!$E4 = "Completed", but it wasn't the right sequence, because it doesn't contain the conditions [Yes and No in col C & D] nor the complimentary task order col B in Sheet1!
- I have also tried to use =VLOOKUP("Eisenhower Matrix"!$D8;$B$4:$E$38;4;FALSE) = "Completed", it didn't work either.
I hope someone can help out there, thanks in advance.
Happy New Year to all of you.
Regards
David
Dec 31 2021 04:27 AM
Please attach a copy of the workbook, or make it available through OneDrive, Google Drive or similar.
Dec 31 2021 04:44 AM
Dec 31 2021 06:58 AM
Thanks! Can you explain in detail what you want to format conditionally and when?
Jan 01 2022 05:21 AM
Jan 01 2022 07:25 AM
I don't understand the sentence "Sheet 1! is conditioned upon [yes & No] furthermore the conditioned upon whether the task is completed or not."
But does the attached version do what you want?
If not, please explain why not.
Mar 08 2023 01:46 PM