Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (2002)

    In H4, I have: =IF(G4>0,G4-F4,"")
    Conditional formatting:
    equal to 0 = green
    less than or greater than 0 = red
    but I want a third, no fill if blank?? Tried =ISBLANK and ="", no joy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting (2002)

    ISBLANK won't work since the cell isn't blank - it contains a formula.
    You must put the condition ="" as the first one, for otherwise, the condition for 0 will pick up the "" values too.
    Unfortunately you cannot shuffle conditions, you'll have to edit them or start from scratch.

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2002)

    < You must put the condition ="" as the first one

    I tried that without success, I will try again. Thanks

  4. #4
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2002)

    Starting from scratch works, but as you say (and I found earlier), editing the existing conditions does not. Thanks again.
    Another question:
    I add a comment using VBA, is is possible to set the length and direction of the arrow? I tried to find out using the macro recorder, but could not get it so set.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting (2002)

    You cannot manipulate the arrow directly, but you can set the Left and Top properties of the Shape property of the comment. This will influence the arrow too. For example:

    Dim rng As Range
    Dim cmt As Comment
    Set rng = Range("G9")
    Set cmt = rng.AddComment("blabla")
    With cmt.Shape
    .Left = rng.Left + rng.Width + 200
    .Top = rng.Top + 100
    End With

  6. #6
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2002)

    Hans, I executed the code and when I right click and edit the comment, it appears approx 4 inches away from the cell, lower to the right, with a long arrow. However, when I just hover over the cell, the comment shows in it's normal place. What I was hoping for (although this really is not that important) was to be able to hover over a comment and it show a few inches above the cell. Thanks

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting (2002)

    If you only show comment indicators, comments will always pop up to the right of the cell they belong to.
    If you show indicators and comments, comments will be displayed where you dragged them.
    You can toggle between the settings using View | Comments (or in the View tab of Tools | Options...)

  8. #8
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (2002)

    Aaaah, I see. I do not want to show comments, only indicators. No worries. Thanks.

Posting Permissions

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