• 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.

Status if not yes and within 7 days

seansr

Member
I need to be able to instantly know of a project is at risk by not receiving details within 7 days of install

I have added an example
In column N, I want it to show "check"
if the install date in P is within the next 7 days (and gone past the date in P (if possible)
of M does not say Yes

I am struggling with the date bit
once I have that I can set conditional formatting to highlight even more
 

Attachments

  • status within 7 days.xlsx
    10.2 KB · Views: 3
how about
=IF(AND(M6<>"yes",P6<=TODAY()),"check","")

you could use the formula as a conditional format and change a cell colours based on that - no need to fill another cell to use conditional formatting
 

Attachments

  • status within 7 days-ETAF.xlsx
    11.1 KB · Views: 4
I have implement this
=IF(AND(P6<=$B$3+7,M6<>"Yes"), "check", " ")
which seems to be working, However how can I change it that if P6 is Blank then still " " ?
so in N if P is empty do nothing
 
you have added a space into the "" - " " adds a space into the cellrather than blank

=IF(AND(P6<>"",P6<=$B$3+7,M6<>"Yes"), "check", "")
 

Attachments

  • status within 7 days-ETAF-1.xlsx
    11.2 KB · Views: 1
seansr
Your However how can I change it that if P6 is Blank then still " " ?
If P6 is empty then ... N6 is empty too.
... what else would You show - if P6 is empty?
 
Back
Top