Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Edith F
 
Posts: n/a
Default format cell based on results of vlookup function

I am using the vlookup function to look at 2 seperate worksheets and take
values from the cells of one or the other worksheet based on the results of
the vlookup and merging the information on a 3rd worksheet. The 3rd
worksheet has a job id which is the lookup value and based on that id, cells
are selected from one of the original worksheets. Some of the original
worksheet cells are formatted a different color (red), but when they are
moved to the 3rd (merged) worksheet they are black (the default color). I
looked at using conditional formatting but don't know how to get it to work
since the result is based on the vlookup function. What I want to do is get
the cells that are red on the original worksheet to be red on the new merged
worksheet. Is there any way to do that as part of the update without having
to manually change the color?
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Are the red cells on the other sheets conditionally formatted? If so, just
use the same logic on sheet3 as is used on the other sheets.

If the cf is based on the value of a cell on a different sheet then you
cannot directly reference that cell in a cf formula. For example, you want
sheet3 A1 fill color to be yellow if sheet1 A1 =10. You would have to do
this by:

Conditional Formatting
Formula is: =INDIRECT("Sheet1!A1")=10

Or, by using a defined name:

InsertNameDefine
Name: Sh1A1
Refers to: =Sheet1!$A$1

Then

Conditional Formatting
Formula is: =Sh1A1=10

Biff

"Edith F" wrote in message
...
I am using the vlookup function to look at 2 seperate worksheets and take
values from the cells of one or the other worksheet based on the results
of
the vlookup and merging the information on a 3rd worksheet. The 3rd
worksheet has a job id which is the lookup value and based on that id,
cells
are selected from one of the original worksheets. Some of the original
worksheet cells are formatted a different color (red), but when they are
moved to the 3rd (merged) worksheet they are black (the default color). I
looked at using conditional formatting but don't know how to get it to
work
since the result is based on the vlookup function. What I want to do is
get
the cells that are red on the original worksheet to be red on the new
merged
worksheet. Is there any way to do that as part of the update without
having
to manually change the color?



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
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Help with function to add percentage to cell based on checkbox. foxgguy2005 Excel Worksheet Functions 3 June 1st 05 05:52 AM
VLOOKUP - results do not appear in cell denvertique Excel Worksheet Functions 1 April 22nd 05 11:41 PM
"count if" function based on value of another cell Anauna Excel Worksheet Functions 3 February 24th 05 07:33 PM
How to use a cell value as Table Array in VLOOKUP worksheet function willydlish Excel Discussion (Misc queries) 2 February 16th 05 03:47 AM


All times are GMT +1. The time now is 05:41 PM.

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"