I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.

You would use Conditional Formatting for this. If you would like
further (more detailed) guidance then please tell us a bit about what
data you have, how it is laid out, and in what circumstances you want
the colour to change.

Pete

On Jan 27, 1:05*pm, Lynz1976
wrote:
I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.

Hi I will be entering a grade into a cell ie Cc or Cb etc. This I will check
against the target grade for the pupil using an if statement or something
similar. This will then return a value which I would like to trigger the
colour of the cell. i.e. if the student its below target Red on target Yellow
ahead of target Green. Can you help with this?

Thanks Lyndsey

"Pete_UK" wrote:

You would use Conditional Formatting for this. If you would like
further (more detailed) guidance then please tell us a bit about what
data you have, how it is laid out, and in what circumstances you want
the colour to change.

Pete

On Jan 27, 1:05 pm, Lynz1976
wrote:
I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.

I assume you will have pupils listed on different rows, with data
going across for each pupil. Which cell/column will hold the target
grade and which cell/column for the actual grade?

I presume you just want the actual grade cell to change colour?

Pete

On Jan 27, 4:00*pm, Lynz1976
wrote:
Hi I will be entering a grade into a cell ie Cc or Cb etc. This I will check
against the target grade for the pupil using an if statement or something
similar. This will then return a value which I would like to trigger the
colour of the cell. i.e. if the student its below target Red on target Yellow
ahead of target Green. Can you help with this?

Thanks Lyndsey



"Pete_UK" wrote:
You would use Conditional Formatting for this. If you would like
further (more detailed) guidance then please tell us a bit about what
data you have, how it is laid out, and in what circumstances you want
the colour to change.

Pete

On Jan 27, 1:05 pm, Lynz1976
wrote:
I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.- Hide quoted text -

- Show quoted text -

Yes each pupil will have their own row of information. Im not sure yet
exactly which cell will hold the target and which the current grade but lets
say for arguments sake the target grade cell is C2 and the current grade cell
is D2. Yes the cell that the current grade is in can change colour that will
be great.

Thanks Lyndsey

"Pete_UK" wrote:

I assume you will have pupils listed on different rows, with data
going across for each pupil. Which cell/column will hold the target
grade and which cell/column for the actual grade?

I presume you just want the actual grade cell to change colour?

Pete

On Jan 27, 4:00 pm, Lynz1976
wrote:
Hi I will be entering a grade into a cell ie Cc or Cb etc. This I will check
against the target grade for the pupil using an if statement or something
similar. This will then return a value which I would like to trigger the
colour of the cell. i.e. if the student its below target Red on target Yellow
ahead of target Green. Can you help with this?

Thanks Lyndsey



"Pete_UK" wrote:
You would use Conditional Formatting for this. If you would like
further (more detailed) guidance then please tell us a bit about what
data you have, how it is laid out, and in what circumstances you want
the colour to change.

Pete

On Jan 27, 1:05 pm, Lynz1976
wrote:
I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.- Hide quoted text -

- Show quoted text -

Okay, well assume you have a header row, so that your first pupil's
data is in row 2. Highlight from cells D2 down to the bottom of your
data, then click on Format | Conditional Format - a panel pops up. In
the first box of this you should select Formula Is rather than Cell
Value Is, and then in the next box you should enter this formula:

=AND(D2<"",D2C2)

Then click on the Format button and select the Patterns tab (for
background colour) and choose Green, then click OK to get back to the
first dialogue box.

Click Add to set up the next condition, choose Formula Is again, and
enter this formula:

=AND(D2<"",D2=C2)

This time click on the Format button, Patterns tab and choose Yellow
(for on target), then click OK.

Click Add once more to set up the final condition, Formula Is, and
enter this formula:

=AND(D2<"",D2<C2)

This time you need to choose Red in the format boxes, then click OK
twice to remove the dialogues.

Excel will have adjusted the cell references to suit the range that
you had highlighted, so you can test it out by putting a value in one
of the C cells and vary values in the corresponding D cell.

Hope this helps.

Pete

On Jan 27, 4:37*pm, Lynz1976
wrote:
Yes each pupil will have their own row of information. Im not sure yet
exactly which cell will hold the target and which the current grade but lets
say for arguments sake the target grade cell is C2 and the current grade cell
is D2. Yes the cell that the current grade is in can change colour that will
be great.

Thanks Lyndsey



"Pete_UK" wrote:
I assume you will have pupils listed on different rows, with data
going across for each pupil. Which cell/column will hold the target
grade and which cell/column for the actual grade?

I presume you just want the actual grade cell to change colour?

Pete

On Jan 27, 4:00 pm, Lynz1976
wrote:
Hi I will be entering a grade into a cell ie Cc or Cb etc. This I will check
against the target grade for the pupil using an if statement or something
similar. This will then return a value which I would like to trigger the
colour of the cell. i.e. if the student its below target Red on target Yellow
ahead of target Green. Can you help with this?

Thanks Lyndsey

"Pete_UK" wrote:
You would use Conditional Formatting for this. If you would like
further (more detailed) guidance then please tell us a bit about what
data you have, how it is laid out, and in what circumstances you want
the colour to change.

Pete

On Jan 27, 1:05 pm, Lynz1976
wrote:
I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Hi,

Use conditional formatting

http://www.contextures.com/xlCondFormat01.html
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Lynz1976" wrote:

I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.

Thanks I will have a look :-)

"Suleman Peerzade" wrote:

Hi,

Use conditional formatting

http://www.contextures.com/xlCondFormat01.html
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Lynz1976" wrote:

I want to get a cell to fill in a particular colour to indicate if one of my
pupils is working ahead or on target. I want excell to execute a check and
fill the cell automatically with the appropriate colour.