Percent Complete Versus Start and End Date Formulas For Conditional Formatting

Status
Not open for further replies.

Consult123

Banned user
Joined
Dec 30, 2023
Messages
22
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hello all,

I'm having trouble with conditional formatting formulas for the following percent complete versus start and end date situations. I've also included a screenshot to give you a better picture.
-On Track (Trigger- Based on the current date, the task will be completed on time by the due date)
-Complete (Trigger- Column F at 100%)
-At Risk (Trigger- Based on the current date (halfway through duration)and percent complete, the task will not be completed on time by the due date)
-Off Track (Trigger- Based on the current date (latter half of duration) and percent complete, the task will not be completed on time by the due date)
-In Progress (Trigger- Column L >1% for the first seven days from the start date)
-Not Started (Trigger- Column F at 0%)
-Cancelled (Trigger- Columns D and E not populated with date and Column L blank)

1703954222171.png
 
well, you've posted what formulas you have. There is a testing area for working with xl2bb, see that link below as well. I'm not sure how the debugging works.
If you can change your TRUST and ADD IN setting in your OPTIONS page you may be able to get that to work. It comes in VERY Handy and you get much quicker responses from the forum when you use it.

The main concern at this point with your workbook is your ambiguity in definitions.
 
Upvote 0

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
in your original post you have a record that is "AT RISK" that is 51% complete. According to your definition above that should be "OFF TRACK".
What is your definition of "DURATION", My guess is Current Date - Start Date.
What about EXACTLY 50% of duration, is that AT RISK or OFF TRACK, when progress is less than 50%?

What if progress is 75% but duration has elapsed 70%? Is that "ON TRACK", or is it "IN PROGRESS", there seems to be ambiguity there as well?


A suggestion for your formula in column L is:

Excel Formula:
=IF(D3="","",IF(D3>Today(),0,Today()-D3+1)/(Today()-D3+1)))
in your original post you have a record that is "AT RISK" that is 51% complete. No, less that 50% of the duration has elapsed but you are still not aligning with column L would be AT RISK. The logic is this, you're still early enough that you can self correct and complete ontime. According to your definition above that should be "OFF TRACK". More that 50% of the duration has elapsed but you are still not aligning with column L would be OFF TRACK. The logic is this, you're now late in catching the variance so it will be tougher to get back back on track and complete on time.
What is your definition of "DURATION", My guess is Current Date - Start Date. Yes, you are correct. Sorry for not explaining that better.
What about EXACTLY 50% of duration, is that AT RISK or OFF TRACK, when progress is less than 50%? No, less than or equal to 50% would be the "AT RISK" and greater than or equal to 51% would be the "OFF TRACK" aka train is detrailing (LOL) category. Does this make sense?

I do a lot of construction scheduling. Projects are hard to get back in line after the 30% or 50% time spent duration becuase you have less time to do so and have usually exhausted most of your finances in early efforts. I hope this makes sense.
 
Upvote 0
well, you've posted what formulas you have. There is a testing area for working with xl2bb, see that link below as well. I'm not sure how the debugging works.
If you can change your TRUST and ADD IN setting in your OPTIONS page you may be able to get that to work. It comes in VERY Handy and you get much quicker responses from the forum when you use it.

The main concern at this point with your workbook is your ambiguity in definitions.
Goals List Creation.xlsx
ABDEFGL
3Task IDTask NameStart DateDue DateActual % CompleteStatusProgress Tracker
4TASK-001Support new user acquisition in targeted regions12/29/2312/1/20241%IN PROGRESS1%
5TASK-002Improve customer satisfaction and reduce churn10/02/231/2/20245%OFF TRACK97%
6TASK-003Bolster revenue from new products and services12/03/2312/3/20241%ON TRACK 8%
7TASK-004Increase upsell and cross-sell revenue from existing customers01/04/2312/4/202450%AT RISK51%
8Q22024
9Task IDTask NameStart DateDue DateStatusProgress Tracker
10TASK-004Ramp up talent acquisition to strengthen teams12/30/202312/30/2023100%COMPLETE100%
11TASK-005Cultivate a customer communityCANCELLED
12TASK-006Increase employee productivity through automation1/3/202412/3/20240%NOT STARTED0%
2024
Cell Formulas
RangeFormula
L12,L10,L4:L7L4=IFERROR(MIN((DATEDIF(D4,TODAY(),"d")+1)/(DATEDIF(D4,E4,"d")+1),100%),0)


I answered my ambiguous definitions in an earlier comment to you. Thanks again for your help!
 

Attachments

  • 1703960791700.png
    1703960791700.png
    21.7 KB · Views: 11
  • 1703960874304.png
    1703960874304.png
    31.4 KB · Views: 10
Last edited:
Upvote 0
You should put formulas in column G, then use conditional formatting to apply colors based on what words are generated by the formulas.

How are you determining, based on the current date, whether a task will be completed by the due date? Are you calculating whether percent of elapsed time is greater than or less than "actual % complete"? How is "Actual % Complete" entered--is it a formula, or entered manually based on some objective measure of completion?

% complete is a notoriously unreliable way to measure task progress. (Cite: 35 years of IT project management experience)
You should put formulas in column G, then use conditional formatting to apply colors based on what words are generated by the formulas. Agreed, but no one has provided formulas. My screen shot is an example of the end product, minus the formulas.

How are you determining, based on the current date, whether a task will be completed by the due date? Are you calculating whether percent of elapsed time is greater than or less than "actual % complete"? How is "Actual % Complete" entered--is it a formula, or entered manually based on some objective measure of completion? Manual input based on percieved complete or logic based decision. Also, see below comment from previous thread.

% complete is a notoriously unreliable way to measure task progress. (Cite: 35 years of IT project management experience) Agreed, but this is for a personal and life goal list which is high level and only scrutinized by me, myself, and I. I don't want to track units becuase some task % completes will be observation based. For instance, studying for a new certification...If I feel I'm about 1/3 of the way through that task I would hard key 30%. I am the only one reviewing the results and I shouldn't be putting in false percent complete numbers. There's less accountability here and only myself to blame if I put in wrong percentages. Does this make sense?
in your original post you have a record that is "AT RISK" that is 51% complete. No, less that 50% of the duration has elapsed but you are still not aligning with column L would be AT RISK. The logic is this, you're still early enough that you can self correct and complete ontime. According to your definition above that should be "OFF TRACK". More that 50% of the duration has elapsed but you are still not aligning with column L would be OFF TRACK. The logic is this, you're now late in catching the variance so it will be tougher to get back back on track and complete on time.
What is your definition of "DURATION", My guess is Current Date - Start Date. Yes, you are correct. Sorry for not explaining that better.
What about EXACTLY 50% of duration, is that AT RISK or OFF TRACK, when progress is less than 50%? No, less than or equal to 50% would be the "AT RISK" and greater than or equal to 51% would be the "OFF TRACK" aka train is detrailing (LOL) category. Does this make sense?

I do a lot of construction scheduling. Projects are hard to get back in line after the 30% or 50% time spent duration becuase you have less time to do so and have usually exhausted most of your finances in early efforts. I hope this makes sense.
 
Upvote 0
The forum is here to help you, not get into arguments with you. If someone says they don't understand or something is ambiguous it is up to you to help them figure why it is not ambiguous, or provide a correction.

Here are your orginal "status" definitions, and any questions I have or updates that you have since answered. If you can't get all of the questions resolved you will not get your conditional formatting rules based on formulas (where as we have already provided CF based on values)

And as far as a formula in column L, a formula was given in post #9. Was that adequate? if it wrong please update with why/how you think it is wrong.


On Track (Trigger- Based on the current date, the task will be completed on time by the due date)
This is vague, according to this statement, any date between the start and end would be "ON TRACK", Is that accurate? Or, would a better definition of this be Actual % Completed >= Progress Tracker %? How does this differ from "IN PROGRESS"?

-Complete (Trigger- Column F at 100%)

-At Risk (Trigger- Based on the current date (halfway through duration)and percent complete, the task will not be completed on time by the due date)
My translation of what you have replied with earlier:
Two Conditions:
Actual Percent < Progress Tracker %,
AND
Progress Tracker is Less Than or Equal to 50%


-Off Track (Trigger- Based on the current date (latter half of duration) and percent complete, the task will not be completed on time by the due date)
My translation of what you have replied with earlier:
Two Conditions:
Actual Percent < Progress Tracker %,
AND
Progress Tracker is Greater Than 50%



-In Progress (Trigger- Column L >1% for the first seven days from the start date)
What if End Date is Less than 7 Days? What status do you want when Actual Status is 5% on Day 3, or 25% on Day 6? (Wouldn't you want "AT RISK", and "OFF TRACK" respectively?) What is the difference between "ON TARGET" and "IN PROGRESS"

-Not Started (Trigger- Column F at 0%)

-Cancelled (Trigger- Columns D and E not populated with date and Column L blank)
You probably do not need to have a test for column L being blank. Of course maybe i don't fully understand this part of the CF.
My suggestion for this would be to just have CF on Columns D & E that they are either both populated or both blank.
 
Upvote 0
in your original post you have a record that is "AT RISK" that is 51% complete. According to your definition above that should be "OFF TRACK".
What is your definition of "DURATION", My guess is Current Date - Start Date.
What about EXACTLY 50% of duration, is that AT RISK or OFF TRACK, when progress is less than 50%?

What if progress is 75% but duration has elapsed 70%? Is that "ON TRACK", or is it "IN PROGRESS", there seems to be ambiguity there as well?


A suggestion for your formula in column L is:

Excel Formula:
=IF(D3="","",IF(D3>Today(),0,Today()-D3+1)/(Today()-D3+1)))
=IF(D3="","",IF(D3>Today(),0,Today()-D3+1)/(Today()-D3+1))) code should start at D4 and include E4 because that is the "timeline to complete," correct? Your
The forum is here to help you, not get into arguments with you. If someone says they don't understand or something is ambiguous it is up to you to help them figure why it is not ambiguous, or provide a correction.

Here are your orginal "status" definitions, and any questions I have or updates that you have since answered. If you can't get all of the questions resolved you will not get your conditional formatting rules based on formulas (where as we have already provided CF based on values)

And as far as a formula in column L, a formula was given in post #9. Was that adequate? if it wrong please update with why/how you think it is wrong.


On Track (Trigger- Based on the current date, the task will be completed on time by the due date)
This is vague, according to this statement, any date between the start and end would be "ON TRACK", Is that accurate? Or, would a better definition of this be Actual % Completed >= Progress Tracker %? How does this differ from "IN PROGRESS"?

-Complete (Trigger- Column F at 100%)

-At Risk (Trigger- Based on the current date (halfway through duration)and percent complete, the task will not be completed on time by the due date)
My translation of what you have replied with earlier:
Two Conditions:
Actual Percent < Progress Tracker %,
AND
Progress Tracker is Less Than or Equal to 50%


-Off Track (Trigger- Based on the current date (latter half of duration) and percent complete, the task will not be completed on time by the due date)
My translation of what you have replied with earlier:
Two Conditions:
Actual Percent < Progress Tracker %,
AND
Progress Tracker is Greater Than 50%



-In Progress (Trigger- Column L >1% for the first seven days from the start date)
What if End Date is Less than 7 Days? What status do you want when Actual Status is 5% on Day 3, or 25% on Day 6? (Wouldn't you want "AT RISK", and "OFF TRACK" respectively?) What is the difference between "ON TARGET" and "IN PROGRESS"

-Not Started (Trigger- Column F at 0%)

-Cancelled (Trigger- Columns D and E not populated with date and Column L blank)
You probably do not need to have a test for column L being blank. Of course maybe i don't fully understand this part of the CF.
My suggestion for this would be to just have CF on Columns D & E that they are either both populated or both blank.
@awoohaw Here is a better version I just created (see below). I have conditional formatting fixed, but I'm having trouble tweaking the formula. See the table on the top right for requirements clarity.
I truly hope my hard work got us moving in the right direction here...

Goals List Creation Rev1.xlsx
ABCDEFGHIJK
1Q12024
2Task IDTask NameStart DateDue DateAct. % ProgressCompleted DateStatusDays RemainingStatus ListDescriptions
3TASK-001Put laundry in hamper12/29/2312/1/2024100%12/1/2024#N/A LATEPast expected completion date
4TASK-002Put laundry in washer10/02/231/2/202421%COMPLETED92AT RISK7 or more days behind schedule
5TASK-003Add detergent12/21/2312/20/202325%AT RISK-1ON SCHEDULEMeeting schedule day for day
6TASK-004Start laundry01/04/2312/4/202445%COMPLETED700AHEAD OF SCHEDULEAhead of schedule by one day or more
7Q22024COMPLETEDate entered into Column G
8Task IDTask NameStart DateDue DateStatusNOT STARTEDNo input in Column E
9TASK-004Move laundry to dryer12/30/202312/22/2023LATE-8
10TASK-005Add dryer sheets12/30/202312/14/2023LATE-16
11TASK-006Start dryer1/3/202412/3/2024COMPLETED335
12Q32024
13Task IDTask NameStart DateDue DateStatus
14TASK-007Remove laundry from dryer1/1/20241/1/2024ON SCHEDULE0
15TASK-008Clean dryer filter1/2/20241/3/2024AHEAD OF SCHEDULE1
16TASK-009Fold laundry1/3/20241/3/2024ON SCHEDULE0
17Q42024
18Task IDTask NameStart DateDue DateStatus
19TASK-010Hang laundry1/1/20241/1/2024ON SCHEDULE0
20TASK-011Iron laundry1/2/20241/2/2024ON SCHEDULE0
21TASK-012Inspect laundry1/3/20241/3/2024ON SCHEDULE0
2024
Cell Formulas
RangeFormula
G19:G21,G14:G16,G9:G11,G3:G6G3=IF(H3="","",LOOKUP(H3,{-999,-1,0,1,10},{"LATE","AT RISK","ON SCHEDULE","AHEAD OF SCHEDULE","COMPLETED"}))
H19:H21,H14:H16,H9:H11,H4:H6H4=DAYS(D4,C4)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
G2:G59Cell Value="NOT STARTED"textNO
G2:G59Cell Value="AHEAD of SCHEDULE"textNO
G2:G59Cell Value="COMPLETED"textNO
G3:G6Cell Valuecontains "COMPLETED"textNO
G2:G59Cell Valuecontains ""textNO
G2:G59Cell Valuecontains ""textNO
J8Cell Value="AT RISK"textNO
G2:G59Cell Valuecontains ""textNO
 
Upvote 0
Updated spreadsheet below; seeking to make inclusive formula for column G that accounts for columns C,D,E,F, and H. I've done most of the hard work, now I need an excel wizard to help with the rest.

Goals List Creation Rev1.xlsx
ABCDEFGHIJK
1Q12024
2Task IDTask NameStart DateDue DateAct. % ProgressCompleted DateStatusDays RemainingStatus ListDescriptions
3TASK-001Put laundry in hamper12/29/2312/1/2024100%12/1/2024#N/A LATEPast expected completion date
4TASK-002Put laundry in washer10/02/231/2/202421%COMPLETED92AT RISK7 or more days behind schedule
5TASK-003Add detergent12/21/2312/20/202325%AT RISK-1ON SCHEDULEMeeting schedule day for day
6TASK-004Start laundry01/04/2312/4/202445%COMPLETED700AHEAD OF SCHEDULEAhead of schedule by one day or more
7Q22024COMPLETEDate entered into Column G
8Task IDTask NameStart DateDue DateStatusNOT STARTEDNo input in Column E
9TASK-004Move laundry to dryer12/30/202312/22/2023LATE-8
10TASK-005Add dryer sheets12/30/202312/14/2023LATE-16
11TASK-006Start dryer1/3/202412/3/2024COMPLETED335
12Q32024
13Task IDTask NameStart DateDue DateStatus
14TASK-007Remove laundry from dryer1/1/20241/1/2024ON SCHEDULE0
15TASK-008Clean dryer filter1/2/20241/3/2024AHEAD OF SCHEDULE1
16TASK-009Fold laundry1/3/20241/3/2024ON SCHEDULE0
17Q42024
18Task IDTask NameStart DateDue DateStatus
19TASK-010Hang laundry1/1/20241/1/2024ON SCHEDULE0
20TASK-011Iron laundry1/2/20241/2/2024ON SCHEDULE0
21TASK-012Inspect laundry1/3/20241/3/2024ON SCHEDULE0
2024
Cell Formulas
RangeFormula
G19:G21,G14:G16,G9:G11,G3:G6G3=IF(H3="","",LOOKUP(H3,{-999,-1,0,1,10},{"LATE","AT RISK","ON SCHEDULE","AHEAD OF SCHEDULE","COMPLETED"}))
H19:H21,H14:H16,H9:H11,H4:H6H4=DAYS(D4,C4)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
G2:G59Cell Value="NOT STARTED"textNO
G2:G59Cell Value="AHEAD of SCHEDULE"textNO
G2:G59Cell Value="COMPLETED"textNO
G3:G6Cell Valuecontains "COMPLETED"textNO
G2:G59Cell Valuecontains ""textNO
G2:G59Cell Valuecontains ""textNO
J8Cell Value="AT RISK"textNO
G2:G59Cell Valuecontains ""textNO
 
Upvote 0
thanks for getting the xl2bb working!
What is you you have not accomplished here? I'm confused. It looks like you have it all. You're calculating your statuses and have it conditionally formatted? Never mind. You want to combine all into one formula. Okay. Will see what I can do. But your column references seem off, G should be F? All offset by 1 column somehow?
 
Upvote 0
thanks for getting the xl2bb working!
What is you you have not accomplished here? I'm confused. It looks like you have it all. You're calculating your statuses and have it conditionally formatted? Never mind. You want to combine all into one formula. Okay. Will see what I can do. But your column references seem off, G should be F? All offset by 1 column somehow?
No, Colum F and G are hard key inputs.

Here's a link to potentially help Earned Schedule Management (ESM) - MPUG
Here's what we are tying to achieve:
1703977368009.png






Known issues:
1. When a date is placed in column F, column H should say "Completed"
2. When no data is in column E, column H should say "Not Started"
3. All other column H conditional formatting from key table to top right not calculating properly.

Goals List Creation Rev1.xlsx
ABCDEFGHIJK
1Q12024
2Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)Status ListDescriptions
3TASK-001Put laundry in hamper1/1/20241/1/2024100%1/1/20240ON SCHEDULELATE>completion date
4TASK-002Put laundry in washer10/02/231/2/202421%92COMPLETEDAT RISK³7 days behind schedule
5TASK-003Add detergent12/21/2312/20/202325%-1AT RISKON SCHEDULEMeeting schedule day for day
6TASK-004Start laundry01/04/2312/4/202445%700COMPLETEDAHEAD OF SCHEDULEAhead of schedule by one day or more
7Q22024COMPLETEDate entered into Column G
8Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)NOT STARTEDNo input in Column E
9TASK-004Move laundry to dryer12/30/202312/22/2023-8LATE
10TASK-005Add dryer sheets12/30/202312/14/2023-16LATE
11TASK-006Start dryer1/3/202412/3/2024335COMPLETED
12Q32024
13Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)
14TASK-007Remove laundry from dryer0ON SCHEDULE
15TASK-008Clean dryer filter0ON SCHEDULE
16TASK-009Fold laundry0ON SCHEDULE
17Q42024
18Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)
19TASK-010Hang laundry0ON SCHEDULE
20TASK-011Iron laundry0ON SCHEDULE
21TASK-012Inspect laundry0ON SCHEDULE
2024
Cell Formulas
RangeFormula
G19:G21,G14:G16,G9:G11,G3:G6G3=DAYS(D3,C3)
H19:H21,H14:H16,H9:H11,H3:H6H3=IF(G3="","",LOOKUP(G3,{-999,-1,0,1,10},{"LATE","AT RISK","ON SCHEDULE","AHEAD OF SCHEDULE","COMPLETED"}))
Cells with Conditional Formatting
CellConditionCell FormatStop If True
H2:H59Cell Value="NOT STARTED"textNO
H2:H59Cell Value="AHEAD of SCHEDULE"textNO
H2:H59Cell Value="COMPLETED"textNO
H3:H6Cell Valuecontains "COMPLETED"textNO
H2:H59Cell Valuecontains ""textNO
H2:H59Cell Valuecontains ""textNO
J8Cell Value="AT RISK"textNO
H2:H59Cell Valuecontains ""textNO
 
Upvote 0
No, Colum F and G are hard key inputs.

Here's a link to potentially help Earned Schedule Management (ESM) - MPUG
Here's what we are tying to achieve:
View attachment 104139





Known issues:
1. When a date is placed in column F, column H should say "Completed"
2. When no data is in column E, column H should say "Not Started"
3. All other column H conditional formatting from key table to top right not calculating properly.

Goals List Creation Rev1.xlsx
ABCDEFGHIJK
1Q12024
2Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)Status ListDescriptions
3TASK-001Put laundry in hamper1/1/20241/1/2024100%1/1/20240ON SCHEDULELATE>completion date
4TASK-002Put laundry in washer10/02/231/2/202421%92COMPLETEDAT RISK³7 days behind schedule
5TASK-003Add detergent12/21/2312/20/202325%-1AT RISKON SCHEDULEMeeting schedule day for day
6TASK-004Start laundry01/04/2312/4/202445%700COMPLETEDAHEAD OF SCHEDULEAhead of schedule by one day or more
7Q22024COMPLETEDate entered into Column G
8Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)NOT STARTEDNo input in Column E
9TASK-004Move laundry to dryer12/30/202312/22/2023-8LATE
10TASK-005Add dryer sheets12/30/202312/14/2023-16LATE
11TASK-006Start dryer1/3/202412/3/2024335COMPLETED
12Q32024
13Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)
14TASK-007Remove laundry from dryer0ON SCHEDULE
15TASK-008Clean dryer filter0ON SCHEDULE
16TASK-009Fold laundry0ON SCHEDULE
17Q42024
18Task IDTask NameStart DateDue DateEV % ProgressCompleted DateDays RemainingSV (Schedule Variance)
19TASK-010Hang laundry0ON SCHEDULE
20TASK-011Iron laundry0ON SCHEDULE
21TASK-012Inspect laundry0ON SCHEDULE
2024
Cell Formulas
RangeFormula
G19:G21,G14:G16,G9:G11,G3:G6G3=DAYS(D3,C3)
H19:H21,H14:H16,H9:H11,H3:H6H3=IF(G3="","",LOOKUP(G3,{-999,-1,0,1,10},{"LATE","AT RISK","ON SCHEDULE","AHEAD OF SCHEDULE","COMPLETED"}))
Cells with Conditional Formatting
CellConditionCell FormatStop If True
H2:H59Cell Value="NOT STARTED"textNO
H2:H59Cell Value="AHEAD of SCHEDULE"textNO
H2:H59Cell Value="COMPLETED"textNO
H3:H6Cell Valuecontains "COMPLETED"textNO
H2:H59Cell Valuecontains ""textNO
H2:H59Cell Valuecontains ""textNO
J8Cell Value="AT RISK"textNO
H2:H59Cell Valuecontains ""textNO


Well, everytime you post a new chart the reference column changes. Its late, I'll have to look more at this tomorrow. Of course other forum folks will chime in if they are interested.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top