|Check out this thread for a couple of options. You'll need to register (free) to download the files that show some examples.|
In addition, I tried something with Conditional Formatting that seems to work. It will need some finessing, but this might get you started:
1 - Insert a line through C10:V10 (20 Cells)
2 - Enter 1 through 20 in C11:V11
3 - Find a character in a Wing Ding type font that you want to use as your indicator. e.g. an R will produce a "spiked circle" in Wing Dings font.
4 - Fill C10:V10 with that character
5 - Select C10:V10 and apply a Conditional Formatting rule of =C11<>$A$1
6 - Set the Format to Font Color = White
Whe you enter a number in A1 that matches a number in D11:V11, your indicator will appear in Row 10 in the matching cell. All non-matching values will be formatted as White and not show up.
With 1 - 20 in C11:V11, you'll only be able to match whole numbers. If you need values such as the 6.5 that you posted, you can make the columns smaller and insert 1, 1.5, 2, 2.5, etc. in Row 11 and use as many columns as you need. The smaller your increments, the more columns you'll need.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.