I have looked and tried, and no luck.
A1 has arrival date
A2 Has drop down list with 1 day, 3 day, 5 day. (I can remove "day", if that helps) (same document sheet called Data)
A3 to turn red if more that (1,3,5 days) Also A3 would be the completed date,
I know this is simple but having no luck.
Thank You in advance.
Brad
Do you know how to enter a "formula" format condition? If so, it sounds like you want to highlight A3 and enter this "formula" conditional format (alt-O-D shortcut, by the way):
=if(A3>A2+A1)
Then I suggest setting the "fill" or "pattern" (not the "foreground" cell font) to red, maybe a light red, in the conditional formatting dialog.
Let me know if I went too fast on that. Also, are you using Excel 2010? (2003 and earlier are different)
Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.
As a rule, if you are working with numbers, it is almost always better to use numbers throughout. So if you are working with days, stick with the qty and leave the text out. As far as excel is concerned, 1 is a number, but 1 day is text, and you cant (easily) run calcs on text.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Ford caught my mistake that I left out telling you that, yes, it's easier if you get rid of "days" from the dropdown, and my solution was based on omitting "days".
One flimsy possible workaround, only if you decided you DO need to keep "days" there, and assuming the first position is always the number (i.e. 1,3, or 5), could be to use
VALUE(LEFT(A2,1))
instead of A2 in the conditional formatting.
I have attached what I'm needing. (I hope its attached)
sorry I did try and even looked more on the website and still can't figure this out.
excel 2010 & 2013
Brad
Hello abadbrad and Welcome to Excel Forum.
Two things that may help:
1. As Ford states values in Sheet2 column A are changed to numbers although custom formatting (0"Days") is applied to Sheet 1 column B.
2. The formula that is used as a conditional formatting rule for column C is: =AND(A2<>"",OR(C2="",C2>SUM(A2,B2)))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I am so sorry for the late thank you..
But thank your answer has helped ...
Thanks Again
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks