Results 1 to 6 of 6

Nested AND IF problem Syntax and solve errors

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Wales
    MS-Off Ver
    Excel 2007
    Posts
    8

    Nested AND IF problem Syntax and solve errors

    Hi,

    I hope someone can help, I am newbie so my apologies if my thread title is incorrect.
    I am creating a simple Gannt chart and am using conditional formatting to display the Gannt bars.
    I use the formula

    #
    =IF(AND(N$9>=$K11, N$9<=$M11),$I11,"")

    #
    This part works well and populates the cell with the value contained within $I11, allowing me to conditionally format the cell in the colour of my choice. However I would like to add a current date timeline. I can do this seprately by using.

    #
    =IF(N9=$U$3,"È","")
    #

    This shows an arrow "wingdings character" when the current week number matches the week header in my gannt chart.

    Problem,
    What I would like to do is combine the first If statement with the second, so under normal conditions the gannt bar is displayed but when its the current week the arrow/character is displayed.

    I am struggling firstly with the syntax and I am uncertain if this is even feasable because i am asking the cell contain to different responses...The arrow/week number is the priority if "true" and then if not the current week number and a task is scheduled for the week display the gannt bar...
    I hope this makes sense...?
    I can attach my work in progress if it helps..

    Thank you to any responses in advance...

    Mike
    Last edited by mikecymru; 01-04-2012 at 11:08 AM. Reason: Solved

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