Conditional Formatting

[Stclements1]

Hello to you all and weekend wishes.

I am devising a Gantt Chart for flying school and ground school. in one row I have the number 18 in certain cells and this represents cadets in ground school in the row beneath I have cells that have 18 in and this determines cadets in flight school and then on the row beneath is a new class of graduates and they have two rows one for ground school and one for flight school.
My question is it possible in excel to conditional format so that when I total the coloum values at the bottom of the chart it only counts the value in the cells that are of a certain fill say brown for ground school and blue for flight school. If not is there a formula that will allow me to get the sum of a coloum counting only cadets in flight school and the sum of a coloum counting only cadets in ground school.

Thank you for your assistance.

 

[mole999]

what version of excel are you using, i think later versions can have the ability

 

[Stclements1]

what version of excel are you using, i think later versions can have the ability

2016

 

[nigelandrewfoster]

I think I understand. Have you tried using COUNTIFS? A quick example:

[TABLE="width: 625"]
<colgroup><col><col span="8"></colgroup><tbody>[TR]
[TD]A TEAM GROUND[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]A TEAM FLIGHT[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD]B TEAM GROUND[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B TEAM FLIGHT[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GROUND[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]FLIGHT[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

If that's what you're after, the fomula in the topmost column total in this example is: =COUNTIFS(B$2:B$5,18,$A$2:$A$5,"*GROUND"), the bottommost
is =COUNTIFS(B$2:B$5,18,$A$2:$A$5,"*FLIGHT"). Change this according to your row headings.

Let me know if you need an explanation of the formulae!

 

[mole999]

have a read here > https://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html

 

[Stclements1]

That has worked absolutely perfect, many many thanks.