Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with VLookup and Offset functions
Hi. 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with VLookup and Offset functions
Am Sun, 10 Jan 2016 02:33:41 -0500 schrieb Phrank:
Hi. 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 Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with VLookup and Offset functions
Hi Frank,
Am Sun, 10 Jan 2016 02:33:41 -0500 schrieb Phrank: Hi. 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. in Sheet1 select your data in column D from D1 on downwards = CF = Formula to determine... : =VLOOKUP(D1,Sheet2!$A$1:$C$100,3,0)="Need" and choose the red fill color Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with multiple sheets and VLookup/Offset | Excel Discussion (Misc queries) | |||
need help using vlookup,max and offset functions! | Excel Worksheet Functions | |||
Offset in Conditional Formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting offset reference | Excel Worksheet Functions | |||
Offset vs vlookup functions | Excel Discussion (Misc queries) |