VLookUp with color

[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

 

[Bob Phillips]

Phil,

You need conditional formatting based upon the value in the cell.

 

[Phil Hageman]

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.

 

[Bob Phillips]

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.