Hi all,
I'm brand new to using formulas for conditional formatting, and this forum. I've had a pretty good search online for a suitable formula without any success, and was hoping someone might create one that will help me achieve the following...
Red highlight for todays date and past dates
Yellow highlight dates up to 30 days before today
No highlights for blank cells or text
I'm using excel 2010.
Thanks in advance!
Catherine
Could you attach a copy of your workbook please? That way we can test solutions on your own data. Remember to replace/remove sensitive data before uploading.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
In your First Statement the Paste Dates correlating with your second statement
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi Tuph, I've attached a snippet of the data set I'll be working with.
Sixthsense, sorry my bad! The second statement should read .....Yellow highlight dates up to 30 days after today.
Hope that makes more sense.
Please confirm the column name which needs to be taken in to consideration for building the formula
The area I'd like to format is b2 - d22 is that what you mean?
Which column date (B or C or D?) needs to be verified for marking color?
Sorry I'm very new to this and I'm not following what you mean, I'm wanting all three collums formatted, but for the sake of this any of them will be fine, lets go with D?
I suggest adding a cell containing today's date for reference purposes. I've done a quick sample in the attachment.
Thanks for your help tuph,
My only issue is that blank cells are highlighted, was hoping to use a formula that would stop this from happening.
Hi
Highlight B2:D22
Look top say Conditional Formatting click on,
click: Manage Rules,
Click: New Rule,
Click: Format only cells that contain,
Keep "Cell Value", next "between" change to "Less than", next NOW()-30 or TODAY()-30
Click: Format,
Look top click: Fill,
Click: Red, (Make sure you see Red in Sample box)
Click: OK ,
Click: OK,
Click: Apply,
Then it you done!!.
Do the same again with(Yellow) and (Blank)
Yellow: =NOW()or TODAY()
Blank: "cell value" change to "Blank" format fill White
Make sure Blank top row then 2nd row Red then last 3rd row yellow in Conditional formatting.
See the file
Regard
micope21
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
That works great, thanks for your help everyone!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks