Changing colour of cells, but wait it is not that simple.

It can be done with conditional formatting, however I cannot see how you know that the student has a target of -1.

I am a teacher, too.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Oh, hang on - is this one row per student?

Three CF formulas:
=(COLUMN()< MATCH($A2,$A$1:$N$1,0))
=(COLUMN()=MATCH($A2,$A$1:$N$1,0))
=(COLUMN()> MATCH($A2,$A$1:$N$1,0))

I have assumed that it IS one row per student

I am confused: some of the target grades in column A do not have matches in row 1: there is no target grade of 1 or 2, for example. Where do these fit in with your grading grid? All of the grades possible will need to be represented along the top.

Anyhow, you need three CF rules applied to the range $B$2:$N$10 (based on your sample):

=COLUMN(B2) < MATCH($A2,$A$1:$N$1,0)
=COLUMN(B2) = MATCH($A2,$A$1:$N$1,0)
=COLUMN(B2) > MATCH($A2,$A$1:$N$1,0)

Snap, Glenn!

Great minds... etc.

Fools, my love, fools ...

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

You're welcome!

An interesting concept - target grades that will never match GCSE outcomes - excellent!!!

PS. If in coulumn with student grades you expect 2 (not 2=) as in the first screenshoit 4 last rows, formulas in conditional formatting could be changed in such way:

Formula:

Please Login or Register  to view this content.