Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 153
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with multiple sheets and VLookup/Offset Phrank Excel Discussion (Misc queries) 3 January 11th 16 11:48 AM
need help using vlookup,max and offset functions! glowdark Excel Worksheet Functions 0 December 31st 10 02:17 AM
Offset in Conditional Formatting? sly411 Excel Discussion (Misc queries) 2 March 22nd 10 09:53 PM
Conditional formatting offset reference IanC[_2_] Excel Worksheet Functions 3 February 17th 10 05:58 PM
Offset vs vlookup functions Darby Excel Discussion (Misc queries) 1 July 9th 08 04:40 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"