Help highlighting cells in a date range

It looks like you have a name in cell A2, so where is the grade really, and where does the date come into it?

I can hardly read your screen shot, and it always helps if you attached a sample Excel workbook, rather than a picture of one.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as that doesn't work on this forum.

Hope this helps.

Pete

Hi again,

Sorry about that I've attached the workbook now. I meant C2 rather than A2 for the grade, each column from C to S is its own grade. The Date would be term and I hadn't added that yet as I wasn't sure which was the best way to go about it. For example

Autumn 1 is between Sept 03 - Oct 20
Autumn 2 is between Oct 21 - Dec 21
Spring 1 is between Jan 03 - Feb 15
Spring 2 is between Feb 22 - April 10
Summer 1 is between April 24 - May 25
Summer 2 is between June 02 - July 20

So if today's date would fall into Spring 1 and for anyone on 40-60w+ to 40-60s+ would be considered on track and that box would be highlighted light green, ELG and ELG+ would be exceeding so highlighted bright green. 40-60b+ & 40-60w would be at risk of falling behind so would be yellow, and then lastly below 40-60 and 40-60b would be well below and highlighted red.

I thought it'd be too difficult for conditional formatting so would need some sort of formula.

Thanks again