Hi:
I am currently using VLOOKUP with cells in the range $A$10:$D$131. I need the cells to return BLUE if they are from A10:A47, GREEN if they are from A49:86, and RED if they are from A108:120. I tried Conditional Formatting using the menu, but it said I couldn't reference other worksheets (plus I wasn't sure if I had the formula correct for referencing text). I'm not real familiar with VB so if an explanation requires that, it needs to be thorough and detailed....
Thanks for your help!
Jeff
I am currently using VLOOKUP with cells in the range $A$10:$D$131. I need the cells to return BLUE if they are from A10:A47, GREEN if they are from A49:86, and RED if they are from A108:120. I tried Conditional Formatting using the menu, but it said I couldn't reference other worksheets (plus I wasn't sure if I had the formula correct for referencing text). I'm not real familiar with VB so if an explanation requires that, it needs to be thorough and detailed....
Thanks for your help!
Jeff