Questions

Conditional Formatting

Tags:
+
0 Votes
Locked

Conditional Formatting

brad.felts
I am trying to apply conditional formatting that if a project is past its deadline the cell shows red (got that part). My question is can I apply conditional formatting to make the same cell green if in the "progress" column for each respective project it shows "delivered". Thank you
  • +
    0 Votes
    1bn0

    Yes!
    Create a second "condition".
    Click on the add button along the bottom of the conditoinal formating dialogue.

    condition #1
    If cell is xx then red

    condition #2
    If cell is yy then green.

    condition # 3
    if cell is zz then yellow

    +
    0 Votes
    ThumbsUp2

    Yes, you can do that. All you need is a compound IF statement. You didn't say what it was that you're using to apply your conditional formatting, but here's the logic:

    IF past the deadline
    - APPLY red to appropriate cell
    ELSE
    - IF delivered
    -- APPLY green to appropriate cell and show delivered
    - ELSE do nothing
    END

    ---

    +
    0 Votes
    jblack

    We need a little more information. Is this Excel or Microsoft Project 2007?

    +
    0 Votes

    I believe you can do this by adding more conditions?
    I think you can add upto 3 conditions from the menu.
    another way to do this would be from the VB editor and just add some code an example would be on a sheet change or update you could have:

    example only,
    Private Sub Worksheet_SelectionChange(ByVal

    Target As Range)
    if range("B15).value > 1 then
    Range(B16).Font.Color = vbRed
    end if

    End Sub

    I use VB Editor all the time to sort these kind of queries but i'm used to it so its quicker for me

    hope it helps

    +
    0 Votes
    ThumbsUp2

    Yes, you can do that. All you need is a compound IF statement. You didn't say what it was that you're using to apply your conditional formatting, but here's the logic:

    IF past the deadline
    - APPLY red to appropriate cell
    ELSE
    - IF delivered
    -- APPLY green to appropriate cell and show delivered
    - ELSE do nothing
    END

    ---

    +
    0 Votes
    jblack

    We need a little more information. Is this Excel or Microsoft Project 2007?

    +
    0 Votes

    I believe you can do this by adding more conditions?
    I think you can add upto 3 conditions from the menu.
    another way to do this would be from the VB editor and just add some code an example would be on a sheet change or update you could have:

    example only,
    Private Sub Worksheet_SelectionChange(ByVal

    Target As Range)
    if range("B15).value > 1 then
    Range(B16).Font.Color = vbRed
    end if

    End Sub

    I use VB Editor all the time to sort these kind of queries but i'm used to it so its quicker for me

    hope it helps

  • +
    0 Votes
    1bn0

    Yes!
    Create a second "condition".
    Click on the add button along the bottom of the conditoinal formating dialogue.

    condition #1
    If cell is xx then red

    condition #2
    If cell is yy then green.

    condition # 3
    if cell is zz then yellow

    +
    0 Votes
    ThumbsUp2

    Yes, you can do that. All you need is a compound IF statement. You didn't say what it was that you're using to apply your conditional formatting, but here's the logic:

    IF past the deadline
    - APPLY red to appropriate cell
    ELSE
    - IF delivered
    -- APPLY green to appropriate cell and show delivered
    - ELSE do nothing
    END

    ---

    +
    0 Votes
    jblack

    We need a little more information. Is this Excel or Microsoft Project 2007?

    +
    0 Votes

    I believe you can do this by adding more conditions?
    I think you can add upto 3 conditions from the menu.
    another way to do this would be from the VB editor and just add some code an example would be on a sheet change or update you could have:

    example only,
    Private Sub Worksheet_SelectionChange(ByVal

    Target As Range)
    if range("B15).value > 1 then
    Range(B16).Font.Color = vbRed
    end if

    End Sub

    I use VB Editor all the time to sort these kind of queries but i'm used to it so its quicker for me

    hope it helps

    +
    0 Votes
    ThumbsUp2

    Yes, you can do that. All you need is a compound IF statement. You didn't say what it was that you're using to apply your conditional formatting, but here's the logic:

    IF past the deadline
    - APPLY red to appropriate cell
    ELSE
    - IF delivered
    -- APPLY green to appropriate cell and show delivered
    - ELSE do nothing
    END

    ---

    +
    0 Votes
    jblack

    We need a little more information. Is this Excel or Microsoft Project 2007?

    +
    0 Votes

    I believe you can do this by adding more conditions?
    I think you can add upto 3 conditions from the menu.
    another way to do this would be from the VB editor and just add some code an example would be on a sheet change or update you could have:

    example only,
    Private Sub Worksheet_SelectionChange(ByVal

    Target As Range)
    if range("B15).value > 1 then
    Range(B16).Font.Color = vbRed
    end if

    End Sub

    I use VB Editor all the time to sort these kind of queries but i'm used to it so its quicker for me

    hope it helps