Hi
I have asked number of experts on youtube but none of them replied I assumed they have no answer.
When I apply filter to any column the Column that contains checkbox overlaps.
Checkbox are in C
Any solution to this issue
I have asked number of experts on youtube but none of them replied I assumed they have no answer.
When I apply filter to any column the Column that contains checkbox overlaps.
Checkbox are in C
Any solution to this issue
Checklist-in-Excel.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | ||||||||||||
2 | To Do List | Status | Cell Linked | |||||||||
3 | Define your project goals | Done | TRUE | |||||||||
4 | Identify all stakeholders | To Be Done | FALSE | Task Completed | 4 | |||||||
5 | Determine your final deadline | Done | TRUE | % of Tasks Completed | 66.7% | |||||||
6 | List each step or task | Done | TRUE | |||||||||
7 | Assign a team member | To Be Done | FALSE | |||||||||
8 | Work backward to set due dates | Done | TRUE | |||||||||
9 | ||||||||||||
10 | ||||||||||||
Checklist |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I4 | I4 | =COUNTIF($F$3:$F$8,TRUE) |
I5 | I5 | =COUNTIF($F$3:$F$8,TRUE)/COUNTIF($F$3:$F$8,"<>") |
D3:D8 | D3 | =IF(F3,"Done","To Be Done") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
D3:D8 | Expression | =$D3="Done" | text | NO |