VLookUp with color

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

The following grading formula enters a letter in D14:
=VLOOKUP(D14,E21:G25,3)
Using this matrix:
FROM TO LETTER
0 143 F
144 167 D
168 191 C
192 215 B
216 240 A
How do I add a background color to this? For example: if
a score was 225, "A" would be entered in D14, as well as a
color background, say index 34.





I would also like to color the background of cell D15
 
Thanks for your reply, Bob. I'm limited to three CFs and
have five letters/colors to deal with. This is why I
thought I should use coding in conjunction with the
VLookUp.
 
Phil,

This would be event code then.

If you want some code, mail me your spreadsheet, tell me what colours go
with what (range of) numbers, and I will knock something up for you.
 
Back
Top