LinkBack URL
About LinkBacks
I am trying to use conditional formatting when the following is true.
Date in cell D5 is older than 10 days from today AND cell D4 is blank; along with if date in D5 is older than 15 days from now AND cell D3 is blank.
Any help would be appreciated.
I am trying to use conditional formatting when the following is true.
Date in cell D5 is older than 10 days from today AND cell D4 is blank; along with if date in D5 is older than 15 days from now AND cell D3 is blank.
Any help would be appreciated.
Assuming you're setting this in a single cell (If it's a range, then do your criteria cells remain constant or do they vary with the range?)
Conditional Formatting>New Rule>Use Formula
=OR(AND(D5< TODAY()+10, ISBLANK(D4)), AND(D5< TODAY() + 15, ISBLANK(D3)))
Assuming that D3 and D4 really are blank cells and not null values ("") or spaces
Is that what you wanted?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I had to tweak the formula a bit, but it worked great for individual cells. Thank you! I guess I should have clarified a bit more. The cells I want this to apply to are all part of a pivot table
that pulls data from an External Access DB. I want to highlight cells that do not have an entry if it has been 5 and 15 days from the date field. If there is data then don't. The attached is an example of what I am looking to do.
Thank you!
I split it up for meeting 1 and meeting 2 with slightly different formatting just to show which is functioning where. You can combine the two formulas with OR.
For meeting 1
=AND(ISNUMBER($C2), NOT(ISNUMBER($C1)), ISBLANK(A2), $C2< TODAY()-5)
For meeting 2
=AND(ISNUMBER($C2), ISNUMBER($C1), ISBLANK(A2), $C2< TODAY()-10)
AND(ISNUMBER($C2), ISNUMBER($C1), ISBLANK(A2), $C2< TODAY()-10)
This one worked too, but not sure how to apply it to the entire pivot table. Do I have to do each individual entry separately?
Thank you!
No, you select your entire range and then you go to conditional formatting and input the formula as it would appear in the first cell. The formula automatically adjusts for the entire range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks