So, in my other life I’m actually a science teacher, and as it usually gets round that I’m “good with computers” I usually get asked to have a look at a few things. Twice in the last few months I’ve been asked if I’d set up conditional formatting in excel to colour code student test results compared to their target grades. Whilst not exactly related to the core content of this site, it is still DIY technical help so I decided to publish a full set of instructions here. Enjoy…
Posts Tagged: microsoft excel
7
Popular
Comments
- MP More Power on The search for a 12 bay 5.25″ full tower case
“I've been on this hunt a few times myself. I still have my Aluminus ultra in black (only 5 5.25…” - CM Chloe Moore on Conditional formatting for grades v targets
“Hi John, Do you have an example of a sheet you have made? Struggling following the steps here!” - JS Jon Scaife on Copy files from Humax PVR 9200T to PC
“Hi Roger That is frustrating. I assume you're on windows 10 or 11? This was from the Windows 7 days…”
“Hi James I realise it has been a long while, but I just checked this on windows 11 (build 23H2)…”