Connect with like-minded professionals and have your say on the issues that matter to you.
Don't forget to look at the how to guide.
Discussion in 'Personal' started by Ming_the_Merciless, Sep 14, 2011.
Welcome to TES, ilovetravel.
Do you see 'geek' as a term of endearment?
I find it offensive.
Hasn't it now become gleek?
easy way is to just fill in the box with a colour,
I use a simple traffic light style system, red below target, yellow on target, green above target
I am picturing your table as follows:
Result 1 in cell A1, Result 2 in cell B1, Result 3 in C1 etc. For the purposes of the following example, your comparison grade is in cell F1. If you want to use A*, just enter a * in the cell.
I assume you know how to do conditional formatting?
Create 3 new rules as follows:
1) For green: =CODE(A$1)<CODE($F$1)
2) For yellow: =CODE(A$1)=CODE($F$1)
3) For red: =CODE(A$1)>CODE($F$1)
Basically you are converting the letters to their corresponding numeric keyboard map value. The letters are normally increasing values. So A is 65 and B is 66. You are then comparing the values.
That's kind of you but I've been here a while...
and yes I do
Thanks for this. I had seen it but is is based on numbers, I have letters. Any further ideas? ( without having to convert them all?)
Thanks Crowbob - will have a go.
I can only post with a delay which is rather frustrating!
Only if you like 'Glee'...