Conditional Formatting with multiple sheets and VLookup/Offset
Hi. I posted this to the WorksheetFunctions group first, but then I
noticed there were only about 6000 posts in that group, so I'm posting
it here in hopes of more people seeing it.
I'm working with Excel 2010. I have two sheets. I have a value
in column D on Sheet1. I need to look up that value in Sheet2, column
A. If that value is there on Sheet2, I need to look at the offset
value in that row that is in column C (still on Sheet2). IF that
value is 'Need', then I need the color of the cell on Sheet1 to change
to Red. I hope that's clear enough.
So, basically it would be a VLookup with an Offset after it finds the
value. Can that formula be done, and can it be worked into
conditional formatting?
Thank you!
Frank
|