Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Using a VLOOKUP command how can I change the cells format?
On EXCEL, I have a global part list on my sheet1. This list includes several columns describing each part. One column is composed of green or red filled cells depending on the part status.
On sheet3 I was able to creat lists for separate models and call its individual bill of materials columns using VLOOKUP, all but the green and red cells, which I don't know how to call.
Here's an example of the function I'm using:
=VLOOKUP(B61,sheet1!$A$2:$E$300,2,FALSE)
how can I make VLOOLUP to understand and reproduce the cell colors or the text format used?
Thanks in advance.
6 Answers
- 1 decade agoFavorite Answer
Sounds to me like you would be better pasting the vlookup cells was values using paste special then use conditional formatting to color the cells which is under format>conditional formatting.
vlookup doesn't bring through conditional formatting and you need to highlight all the cells you want included in the formatting before selecting conditional formatting too or it only does the one cell.
Hope that makes sense.
- 1 decade ago
VLOOKUP will let you manage the DATA for the cell. Conditional Formatting will let you manage the Format based on the DATA.
So, define the conditional format for one cell and copy the formatting over to the rest of the cells which have to behave similarly,
Good luck!
- Anonymous6 years ago
reverse phone number search compiles hundreds of millions of phone book records to help locate the owner's name, location, time zone, email and other public information.
Use a reverse phone lookup to:
Get the identity of an unknown caller.
Identify an area code.
Recall the name of a person whose number you wrote down.
Identify an unfamiliar phone number that shows up on your bill.
- How do you think about the answers? You can sign in to vote the answer.
- 1 decade ago
You cant. Best thing you could do is use Conditional Formatting, but not sure if it will work in your case.
- Anonymous1 decade ago
computer programming service,web site design,homework help
custome website design etc, at


