Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic Totals/Coloured Cells
Hi all,
This is probably very straight forward, but I hope someone can assist. I have a spreadsheet with information about students in a school. Their names and other information are in columns A - D, and their grades are in column E onwards. The grades are normally something like "3C" or "5A" etc, sometime just Y(es) or N(o). Could someone provide me with a quick formula to total up how many students achieved a particular grade in each column (so for example, how many students have 3C against their name in column E). Along with this, I wondered if there was some programming I could do to make a particular cell change colour when text is typed into it (for example all cells containing 5A turn red automatically). Thanks in advance for any help offered. |
#2
|
|||
|
|||
Hi Ian,
try this for sum =countif(E:E,"3C",A:A) formatconditional formatingcell value isis equal to5a and press formal botton and select the color and for coloring the cell use conditional formation "Ian.UK" wrote: Hi all, This is probably very straight forward, but I hope someone can assist. I have a spreadsheet with information about students in a school. Their names and other information are in columns A - D, and their grades are in column E onwards. The grades are normally something like "3C" or "5A" etc, sometime just Y(es) or N(o). Could someone provide me with a quick formula to total up how many students achieved a particular grade in each column (so for example, how many students have 3C against their name in column E). Along with this, I wondered if there was some programming I could do to make a particular cell change colour when text is typed into it (for example all cells containing 5A turn red automatically). Thanks in advance for any help offered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic Colour of Cells in Excel | Excel Discussion (Misc queries) | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |