Working with Excel 2010. I am requiring the ID number in cell a1 to turn red if "u1" is blank or the date is 28 days past the date in c1.
would you all be able to help..?
Working with Excel 2010. I am requiring the ID number in cell a1 to turn red if "u1" is blank or the date is 28 days past the date in c1.
would you all be able to help..?
Conditional Formatting> New Rule> Use Formula> =OR(ISBLANK($U1), TODAY()> $C1+28)
Does that work for you?
Is U1 really blank or does it contain "" or 0
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks