• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional formatting

A

Ashley

New Member
Hello!

I have raw data that needs conditional formatting for dates.

I have an column of dates that represents the day that each appraisal was ordered on.

And I have another column of dates that represent the day that each appraisal was received on.


I need to set up conditional formatting that turns red when the date range between the day the appraisal was ordered is greater than 7 days of it being received.
 
Thank you. that would work great except that my dates are not based off of the current week. so the =($L$2-TODAY)formulas do not work.


For instance, cell J2 is the date 8/29/2011, and cell L2 is the date 9/2/2011. I need cell L2 to turn red since the time between the two dates is greater than 2 days.
 
Ashley, try removing the "$" on your last message. You don't want the condition to fix at cell L2.
 
THAT WORKED PERFECTLY!! THANK YOU!

Now is there Conditional formatting for an AND statement such as

=L2-J2>7 (red) AND L2-J2="BLANK"


So that if the cell is blank it will remain blank rather than be red?
 
You must log in or register to reply here.
Back
Top