M
Manxy
With help from members, I have the following formula and have added 3 colours
to the conditional formatting section, being red for the top, orange for the
middle and lastly yellow for the bottom one. Basically, any red cells
indicate persons who are out of date and need urgent training (in my
case-First Aid but could be used for other training purposes), the orange
indicates an orange cell which implies to me, 'Get my skates on and get
something organised quickly' and the yellow indicates 'Hello, I need to be
considered for training soon'
=AND(G3<>â€â€,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY())
=DATEDIF(G3,TODAY(),â€mâ€)=11
=DATEDIF(G3,TODAY(),â€mâ€)=10
I currently have 3 columns with the above conditions applying;
D3 to D48
K3 to K48
P3 to P30
I would like all those cells in the 3 columns to add up and show different
statistics.
For instance
In Date: Any conditional formatting cells coloured white, orange and yellow
cells, but does not include those out of date which is the pink cells. These
are to add up and placed in cell P35
Out of Date: Any conditional formatting cells coloured red are classed as
out of date (as per line one) and the 3 columns with this formula add
together to make a total in cell P36
Thanks to those who've helped so far and thanks to those in advance.
-----------------------------------------------------------------------------
to the conditional formatting section, being red for the top, orange for the
middle and lastly yellow for the bottom one. Basically, any red cells
indicate persons who are out of date and need urgent training (in my
case-First Aid but could be used for other training purposes), the orange
indicates an orange cell which implies to me, 'Get my skates on and get
something organised quickly' and the yellow indicates 'Hello, I need to be
considered for training soon'
=AND(G3<>â€â€,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY())
=DATEDIF(G3,TODAY(),â€mâ€)=11
=DATEDIF(G3,TODAY(),â€mâ€)=10
I currently have 3 columns with the above conditions applying;
D3 to D48
K3 to K48
P3 to P30
I would like all those cells in the 3 columns to add up and show different
statistics.
For instance
In Date: Any conditional formatting cells coloured white, orange and yellow
cells, but does not include those out of date which is the pink cells. These
are to add up and placed in cell P35
Out of Date: Any conditional formatting cells coloured red are classed as
out of date (as per line one) and the 3 columns with this formula add
together to make a total in cell P36
Thanks to those who've helped so far and thanks to those in advance.
-----------------------------------------------------------------------------