+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting count

  1. #1
    Registered User
    Join Date
    05-14-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Conditional Formatting count

    I'm trying to create conditional formatting that will do the following:
    A3= today's date
    I10: The due date

    Anything due before today's date= Red
    Anything due within 5 business days of A3= Yellow
    Anything due beyond 5 business days of A3= Green

    I've created the following conditional formatting rules: =IF($A$3>WORKDAY(I10,2,$M$5:$M$6),TRUE,FALSE) [will be red] =IF($A$3>=WORKDAY(I10,2,$M$5:$M$7),TRUE,FALSE) [will be yellow] =IF($A$3<=WORKDAY(I10,6,$M$5:$M$6),TRUE,FALSE) [will be green]

    I also need a way to count the amount of reds, yellows, and greens, without using a macro. I have used this formula, but it's not working properly: =IF(J10="","",IF(J10="Complete",4,IF(J10<$A$3,1,IF(J10=$A$3+(WORKDAY(I10,6,$M$5:$M$6)),3))))) Upon receipt, I will give the file.

    None of my formulas are working. Any help?

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Conditional Formatting count

    this =IF($A$3>WORKDAY(I10,2,$M$5:$M$6),TRUE,FALSE)

    should be =$A$3>WORKDAY(I10,2,$M$5:$M$6)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1