Consulting

Results 1 to 8 of 8

Thread: Conditional formatting

  1. #1

    Conditional formatting

    <DIV id=post_message_1553111>Hi,

    I have a range of cells that conatain 3 conditions

    1) =ISERROR(R11)

    2) =R11

    <DIV id=post_message_1553111>Hi,

    I have a range of cells that conatain 3 conditions

    1) =ISERROR(R11)

    2) =R11
    Last edited by 007juk; 04-26-2008 at 02:06 PM. Reason: problem when I inserted link

  2. #2
    Apologies don't know what happened with 1st post.

    <DIV>Hi,

    I have a range of cells that conatain 3 conditions

    1) =ISERROR(R11)

    2) =R11

  3. #3
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    oh seven, Could you explain your question please?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  4. #4
    Sorry Lucas, won't let me post it. Keeps coming up with that <DIV id post???

    In my first post I tried to post a link, think that caused the problem.

    Thanks.

  5. #5
    I have a range of cells that conatain 3 conditions

    1) =ISERROR(R11)

    2) =R11

  6. #6
    I have a range of cells that contain 3 conditions

    1) =ISERROR(R11)

    2) =R11

    3) =R11>TODAY() formatted green

    a) If cell R11 is true (contains a expiry date then format red)

    b) If cell R11 is true (contains a live date then format green)

    c) If cell R11 is false (doesn't conatin a date yet formats green)

    In relation to (c) I want it to remain blank and not to format green, because it doesn't contain a date.

    Many thanks,

  7. #7
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    007,
    Please stick to one thread to get help. You created 3 new threads asking the same question. I know you are having trouble posting but lets try to solve it in this thread.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  8. #8
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    =AND(R11<>"",R11>TODAY())
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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