Good Day,
I am looking to be able to have data removed(or highlighted) on sheets 2 and 3 when I enter that specific data into sheet one. I just want to make sure I am able to look at sheet two or three and see that the data has been entered in sheet one so not to duplicate it on sheet one.
Any suggestions?
Thanks
Skiman
Hi
CF is 1 way to go
Formula:
Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
This is great, Fotis. Thank you for your time!
Skiman
You are welcome and thanks for the feed back.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
I'm not sure if I can do this but I have a follow up to this.
If there is data located all over sheets 2 and 3(not just one column), could data be pulled from all over the sheet instead of only one column? Is this a simple adjustment to include the entire sheet? And I would like to be able to enter the searchable data(sheet 1) anywhere on that sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks