Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have a program composed in two sheets one with data and…

Customer Question
I have a program...

I have a program composed in two sheets one with data and one that receives whaever I write on the data sheet using the formula=DATA!$B$2 and changing the figures according to the cell I want filled and placed on the sheet receiving information, what I want to be done is that whenever a cell is filled and transferted to the receiiving sheet that the cell on the receiving sheet changes to a certain color always the same color for whaever cell is changed, Can it be done? Thanks for your answer

Technician's Assistant: What application are you using?

Excel 2016

Technician's Assistant: Have you updated Excel recently?

Yes

Technician's Assistant: Anything else you want the Microsoft Office Expert to know before I connect you?

Just the answer if there is one - Thanks

Submitted: 4 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 2 hours by:
12/2/2017
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,350
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified

Can you please upload the Excel sheet for review? This will be easier for understanding. Thanks.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago

Hello, are you still there with me?

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
I have enclosed a copy of the form, and I have added a third sheet(FORM2) to show what I want to be done once the data is written on the DATA sheet. some formulas have been placed on combined cells as is the case of names and explanations which require more space when filled, so in a few words what I want is that those formulas that become active in the FORM change to a fill color to distinguish them from the rest and make them more easy to read looking just to the color filled cells (the form will be printed at all times for distribuition)
Customer reply replied 4 months ago
I can not change the amount invoiced since I have contacted my customer and he has approved the initial amount of $543.00 Pesos initilally quoted, anyway thanks for the opportunity to do it faster.
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago

You can do this using Conditional Formatting. For example,

1. Click the cell to be automatically highlighted for receiving value.

2. Choose Condition Formatting > Highlight Cells Rules > More Rules

3. Choose No Blanks at Format only cells with.

4. Click Format... button then Fill tab then choose a colour, click OK button

Be aware the condition in the above method, the original data field must be blank (such as " ") in order to turn off highlights in the receiving sheets.

Please see attache the screenshot and my sample in your workbook for your reference.

Please let me know if it is something you are after. Thanks.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago

FYI - you may change the rule from "No Blanks" to equal or not equal given value for a number field (non-text field).

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
BBAO: I haved done what you proposed I highlighted the cells which I am interested to change when a CHANGE IN THE DATA SHEET GOES ON, but this didnt happen since all the cells were highlighted in yellow, lets say that if I only cj¿hange or write in one of the cells of the DATA sheet like I have done in the enclosed sample file then only that cxell in the QDR sheet would change, that is what I want to happen and once all the cells have been placed blank on the DATA sheet the highlighting on the QDR sheet also goes blank (only the formula stays put., I hope I have been explict of mwhat I need - Thanks
P.S.See the commentary notes on the cells in the DATA and QDR sheets .
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago

Thanks for sharing your workbook.

> CHANGE IN THE DATA SHEET GOES ON

basically, this way (using conditional formatting) does NOT support detecting any changes in the datasheet goes on. It only supports detecting blank or non-blank (data filled in) in the datasheet.

In other words, if a cell changes from blank to any value, or from any value to blank, it will show highlighted or not highlighted.

If a cell changes from a value to another, say from 1 to 2, or from "abc" or "efg", it won't be detected, or highlighted.

Moreover, as mentioned above blank means at least one space " ", empty field such as null doesn't mean blank. I changed F3, F6 and F13 to blank just as a demo for you. Please see attached your file revised.

Thanks.

Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
BBAO: I have used the example you sent, the first thing I did was to remove the in formation from the DATA sheet, and the yellow color persisted on the QDR sheet, in orde to get finished this proiblem what I need is that all the cells in the QDR sheet who has a formula, whenever there is information on the DATA sheet that affects the formula on any certain cells (this can be depending on what the user wants to be done) then highlight the cell on the QDR form, When. the DATA sheet has been cleaned of thne information, then also the cells on the QDR form are cleaned of the highlight color, if this can not be done in Conditional Formatting, perhaps cen be done with a VBA program, I don't know I am not that expert to know, and that's the reason I have asked to Just Answer, I am very pleased with all the effort you have placed on this problem - Thanks
Customer reply replied 4 months ago
Hi, BBAO Are you still interested in tackling my problem? let me know so whatever your answer is then I will take action in order to find it solved. I thank you in advance your prompt reply, - ADLG
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago
> first thing I did was to remove the in formation from the DATA sheet, and the yellow color persisted on the QDR sheet.
> user wants to be done) then highlight the cell on the QDR form, When. the DATA sheet has been cleaned of thne information, then also the cells on the QDR form are cleaned of the highlight color,I guess you haven't noticed the point below that I have mentioned twice aboveBe aware the condition in the above method, the original data field must be blank (such as " ") in order to turn off highlights in the receiving sheets> perhaps cen be done with a VBA programNot necessary, and it will make things complicated.However, I think a remote session is really necessary now, as in that interactive way I can demonstrate what to do and you can clearly understand the tricks.
Ask Your Own Microsoft Office Question
Customer reply replied 4 months ago
Hi, I just asked my son to bring my laptop to the hospital since I have been hit with Influence and with high temperatures, I still will remain here a few days, so when I return home we will continue with this problem in the meanwhile see if you can fullfill what my customer wants with this program otherwise if you can not tackle this problem, perhaps some other consultant would find a way to see it happen - Thanks (this message has been written by my son since I am not well enough to do it)
Microsoft Office Technician: bbao, IT Consultant replied 4 months ago

Thanks heaps for your update. Please take your time to recover fully. No worries. Take care.

Ask Your Own Microsoft Office Question
Was this answer helpful?
Ask bbao Your Own Question
bbao
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,350
1,350 Satisfied Customers
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP

bbao is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

588 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I just purchased Microsoft office for home, 365. I stopped
I just purchased Microsoft office for home, 365. I stopped getting e-mails at 5:14 PM. I'm getting an error message when mail trying to be received. Have rebooted, laptop, turned wireless box Off & On… read more
Ameen Khan
Ameen Khan
Senior IT Support Specialist
Information Technology Management / Computer Science
1 satisfied customers
I'm trying to install Office 365 on a new computer. It keeps
I'm trying to install Office 365 on a new computer. It keeps asking for my account email which I enter, but then it asks for password, which I obviously have forgotten … read more
Moses C
Moses C
Bsc
564 satisfied customers
Iwas/am a publisher; a one-man show,
Iwas/am a publisher; a one-man show, MauveEnterprise_Publishing. I have lost my MauveEnterprise or mauveenterprise @gmail.com link. It's a business. Is the connection still functioning? How can I hook… read more
bbao
bbao
IT Consultant
1,350 satisfied customers
I purchased Office Professional Plus 2016 through home use
I purchased Office Professional Plus 2016 through home use program where I work. I have Windows 10 OS on an HP 510 computer. A little over half way through the install, I get an error code 30088-4. … read more
Cody
Cody
Computer Science
2,154 satisfied customers
I can not send a word document via text; says MAPI failure,
I can not send a word document via text; says MAPI failure, operation not supported? How can I send document via text? … read more
bbao
bbao
IT Consultant
1,350 satisfied customers
After a Microsoft update download last week I got a black
After a Microsoft update download last week I got a black screen with only the mouse and Task manager working. We go many of the functions back but a number of Microsoft functions (apps) no longer wor… read more
bbao
bbao
IT Consultant
1,350 satisfied customers
I am trying to move MS Office home and student 2010 to a new
I am trying to move MS Office home and student 2010 to a new laptop. I was told when I purchased it several years ago that I could have it on up to three computers. This will be my 3rd. The key code I… read more
Cody
Cody
Computer Science
2,154 satisfied customers
I installed word 10 and documents will not print on my
I installed word 10 and documents will not print on my printer … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
802 satisfied customers
I have lost my information regarding my WEP Key to activate
I have lost my information regarding my WEP Key to activate my sofware … read more
Cody
Cody
Computer Science
2,154 satisfied customers
I have to update my MS Word but I don't have my passcode for
I have to update my MS Word but I don't have my passcode for it, please help. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
I have a new edition of MS Office including Excel. I am
I have a new edition of MS Office including Excel. I am having trouble with Excel preventing me from accessing my files as I get a message "Access denied - contact you administrator". As I am the only… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,395 satisfied customers
Team - I can no longer access any of my Microsoft documents
Hi Team - I can no longer access any of my Microsoft documents online - how do I go about re0installing Microsoft Office please? … read more
Moses C
Moses C
Bsc
564 satisfied customers
I recently purchased a pc at Naples store with full geek
I recently purchased a pc at Naples store with full geek service. they converted all file etc but not Outlook. I have Windows 10 pro. What does it take to get Outlook within these paramaters … read more
Ricky Kresslein
Ricky Kresslein
Bachelor\u0027s Degree
784 satisfied customers
Can't change/update EXCEL monthly spreadsheet online. I
Can't change/update EXCEL monthly spreadsheet online. I don't have luck with changing key names: 42118 is the update on previous Feb spreadsheet. … read more
bbao
bbao
IT Consultant
1,350 satisfied customers
Just got a critical alert from microsoft saying i have been
just got a critical alert from microsoft saying i have been invaded by a virus and i was suppose to call them is this fake … read more
Kamil Anwar
Kamil Anwar
IT Consultant / Systems Engineer
Bachelor\u0027s Degree
458 satisfied customers
It takes an inordinate of time to open a Word document.
It takes an inordinate amt of time to open a Word document. … read more
Cody
Cody
Computer Science
2,154 satisfied customers
HOW DO I FIND OUT MY MICROSOFT KEY PRODUCT? MICROSOFT OFFICE
I KEEP GETTING POP UP NOTICE TO ACTIVATE MICROSOFT OFFICE.… read more
Michelle
Michelle
Manager operations
Bachelor\u0027s Degree
1,276 satisfied customers
Trying to update windows 10, keep getting error code
trying to update windows 10, keep getting error code 0x80072ee7 … read more
Cody
Cody
Computer Science
2,154 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x