How JustAnswer Works:

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

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9654
Experience:  Worked on Macs and PC's for 20+ years.
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

I would like a cell to change color, when a date I enter into

Customer Question

I would like a cell to change color, when a date I enter into the cell, is reached or exceeded.
Submitted: 3 years ago.
Category: Mac
Expert:  John D replied 3 years ago.

Hi,

 

Ok

 

1) which cell do you want to change the color of

2) what is the date that cell should not exceed (or in which cell is that date)

3) which color do you want to change it to

 

 

 

Customer: replied 3 years ago.
would you like a copy of the basic speadsheet I want to develop? This spreadsheet will provide me a high level look at the progress of matters I am responsible for. As one item reaches conclusion, I will add another to the spreadsheet. There will be seven columns, and 15 or more rows. Each cell in a row will have a date entered which I would like to change to the color red when the date in the cell is reached or exceeded. The cell would remain red until I delete the date and enter the word "completed"
Expert:  John D replied 3 years ago.

Ok so you want a general answer rather than me helping you set up the specific conditions?

 

 

Customer: replied 3 years ago.
Well, I am not able to write the formula which will provide the result I need. I have tried to add conditional formats to the cells, but none have worked for me.
Expert:  John D replied 3 years ago.

If you want me to help you with that formula you need to provide me with specific details. I asked you a few questions but I have not received the answers yet

 

 

Customer: replied 3 years ago.
Can you provide me the conditional format formula necessary to provide the result I need? There will be over seventy cells, each cell will have a different date I am monitoring.
Expert:  John D replied 3 years ago.

I can, but i doubt you will be able to make use of it as I do not have any info about the date in question, or in which cell it is located.

 

I suggest that you send me your file so I can set it up for you and ensure that it will work. But if you insist that I give you the formula(s) here I will need to get an accept to make sure I get compensated if it turns out that you cannot make it work

 

Customer: replied 3 years ago.
how do I send you the file?
Expert:  John D replied 3 years ago.

Ok, go to http://www.sendspace.com/ and upload the file there (no need to sign up). You will then get a page that has the download link. Copy the download link and come back here and paste it in your reply.

 

If the file has sensitive information let me know before you upload it, or just try replacing the sensitive data with dummy values.

 

Customer: replied 3 years ago.
Nothing sensitive, I will put the data on the spreadsheet when it is completed.

http://www.sendspace.com/file/tn1b58
Expert:  John D replied 3 years ago.

Ok I am looking at your file now. Cells E4, F4 and G4 have conditional formatting which turns the cell to red if the date in that cell is greater or equal to the date in C1

 

Do you want to change the rules for these cells, if so what is the new rule that you want to apply?

 

 

Customer: replied 3 years ago.
I want the rule to apply to cell C3 through cell H18. I will enter a date into each cell. The cell will remain white until the date in the cell is reached or beyond. When the cell turns red, I will be alerted that a due date has been reached or exceeded.

I want to track reports which have various due dates. If a due date is reached or exceeded, I want to be alerted.

Take the example on row 4.
cell B4 shows the date I received a report.
cell C4 shows the date the investigation is due (future date). If the investigation is not completed by 1/24/11, the cell will turn red, The cell will remain red each day past 1/24/11, or until I remove the date and replace the word "completed" in the cell, and so on with cell D4, E4, F4, G4, H4 and each row thru row 18.

I may need an additional page, so I would like to be able to copy the formula, or page as needed in the future.

As you can see, my formula does not provide the effect I desire.

This is an interesting process, difficult to explain what I need.

I hope this helps.??
Expert:  John D replied 3 years ago.

Ok here you go

 

The cells in the range C3:H18 will turn red if the date in them has been reached or exceeded

 

https://sites.google.com/site/zworkbook/zworkbook

 

Hope this is ok. Please have a look at it and let me know if it needs any adjustments or if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

 

John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9654
Experience: Worked on Macs and PC's for 20+ years.
John D and 4 other Mac Specialists are ready to help you
Customer: replied 3 years ago.
John D.,

Thank you very much. Sorry I could not respond sooner and accept answer. The formula acts as I desire. Thank you for your kind assisstance.

T. K.
Expert:  John D replied 3 years ago.

Great! You're welcome and thanks for the accept and bonus

 

 

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:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • 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 Customer New 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!!!! Alex Los 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. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified