Ask Mac Questions and Get Answers from Experts ASAP
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
Ok so you want a general answer rather than me helping you set up the specific conditions?
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
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
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.
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?
Ok here you go
The cells in the range C3:H18 will turn red if the date in them has been reached or exceeded
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
Great! You're welcome and thanks for the accept and bonus