Excel Help

houst69

Striker
I need cells that go green that are within a date range. For example between 01 Apr 18 and 31 Mar 19. I am struggling to find info online for this.

Once these dates go green (there are 16 different tests) I need the completion rate at the end so if dates are entered in the column it gives a final %

Anybody help?
 


If you mean you want to show the percentage of tests completed then a simple =COUNTA() function should count all the cells with entries in them and you can divide that by 16

So, assuming your cell range was B1:Q1, in cell R1 you could put the fomula =COUNTA(B1:Q1)/16
Format the cell as a % and there you have it
 
If you want to count cells of a certain colour then you'll need a macro (although I suppose it could be done by other means). I have a sheet that does this.
 
Always needing help you
I assume that he's on a wind up. Nobody could set up a web development business and be this feckless.
It's like me setting myself up as a mechanic and not knowing how to open the bonnet of the car. Or what the bonnet is called.
The only other option is that he's blagged a role at work that is totally incapable of doing.
 
I need cells that go green that are within a date range. For example between 01 Apr 18 and 31 Mar 19. I am struggling to find info online for this.

Once these dates go green (there are 16 different tests) I need the completion rate at the end so if dates are entered in the column it gives a final %

Anybody help?

I did something similar without using a macro but a ‘cheat’ column.

Set the conditional formatting as suggested above, then include an additional column to the right of every one which you wish to measure completion. In the cell to the side, include a countif formula (possibly sumif?) it return the letter ‘x’ when the criteria is met.

Then in the cell where you want to measure progress, add countif formula to the cheat column for the letter ‘x’. Then hide the cheat column.

It’s messy, but it works if you can’t use macros.
 
Few years ago my boss highlighted some cells then proceeded to get his calculater out to add the numbers together :eek:
I've seen people do that and then complain the numbers don't seem right cos the missed a row.
Should be a disciplinary imo, can you imagine getting a job as a CNC operator and then hand cutting shit with a hacksaw and asking the SMB how to get it to line up straight.
 

Back
Top