+ Reply to Thread
Results 1 to 1 of 1

Gnatt chart - Need help with Ifand formula

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    Waterlo, Ont
    MS-Off Ver
    Excel 2003
    Posts
    20

    Gnatt chart - Need help with Ifand formula

    I need some assistance to the current formula that I'm using.

    Right now the current formula only takes into consideration the dates between Column L and M and highlights those cells in blue. The formula that I have used is =IF(AND(P$9>=$L23,P$9<=$M23),1,"")

    I've included the excel file, so it helps determine exactly what I'm trying to do.

    Now what I would like to do is include the dates from K to L and have those highlighted in the chart to green. I still need the dates between Colum L and M to remain highlighted blue. I've already completed a conditional formatting that the number 2 will change the colour of the cell to a light green. I just need a little help with the formula to include the dates from K-L and L-M.

    Any help is greatly appreciated.

    Thanks
    Attached Files Attached Files
    Last edited by Kristina1976; 01-10-2011 at 05:04 PM. Reason: inlcuded attachment

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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