Conditional Formatting

Stclements1

Board Regular
Joined
Sep 15, 2018
Messages
120
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,516
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
what version of excel are you using, i think later versions can have the ability
 

nigelandrewfoster

Well-known Member
Joined
May 27, 2009
Messages
735
I think I understand. Have you tried using COUNTIFS? A quick example:

A TEAM GROUND18181818
A TEAM FLIGHT18181818
B TEAM GROUND181818
B TEAM FLIGHT18181818
GROUND11101201
FLIGHT02110211

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>

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!
 

Stclements1

Board Regular
Joined
Sep 15, 2018
Messages
120
Office Version
  1. 365
Platform
  1. Windows
That has worked absolutely perfect, many many thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,918
Messages
5,525,624
Members
409,657
Latest member
19JimRon72

This Week's Hot Topics

Top