+ Reply to Thread
Results 1 to 7 of 7

conditional formatting for Error

Hybrid View

  1. #1
    krupesh
    Guest

    conditional formatting for Error

    Hi Friends
    I want to format those Cells which contains any error. I have tried in
    conditional formatting with as Formula is =ISERROR, but it is not
    working. can any one help on this

    Thank you


  2. #2
    Bob Phillips
    Guest

    Re: conditional formatting for Error

    Select your cells and use the cell referen ce of the first, such as

    =ISERROR(A2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "krupesh" <k.bhansali@rediffmail.com> wrote in message
    news:1123176824.727318.31260@g44g2000cwa.googlegroups.com...
    > Hi Friends
    > I want to format those Cells which contains any error. I have tried in
    > conditional formatting with as Formula is =ISERROR, but it is not
    > working. can any one help on this
    >
    > Thank you
    >




  3. #3
    Bob Phillips
    Guest

    Re: conditional formatting for Error

    Select your cells and use the cell referen ce of the first, such as

    =ISERROR(A2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "krupesh" <k.bhansali@rediffmail.com> wrote in message
    news:1123176824.727318.31260@g44g2000cwa.googlegroups.com...
    > Hi Friends
    > I want to format those Cells which contains any error. I have tried in
    > conditional formatting with as Formula is =ISERROR, but it is not
    > working. can any one help on this
    >
    > Thank you
    >




  4. #4
    Bob Phillips
    Guest

    Re: conditional formatting for Error

    Select your cells and use the cell referen ce of the first, such as

    =ISERROR(A2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "krupesh" <k.bhansali@rediffmail.com> wrote in message
    news:1123176824.727318.31260@g44g2000cwa.googlegroups.com...
    > Hi Friends
    > I want to format those Cells which contains any error. I have tried in
    > conditional formatting with as Formula is =ISERROR, but it is not
    > working. can any one help on this
    >
    > Thank you
    >




  5. #5
    Bob Phillips
    Guest

    Re: conditional formatting for Error

    Select your cells and use the cell referen ce of the first, such as

    =ISERROR(A2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "krupesh" <k.bhansali@rediffmail.com> wrote in message
    news:1123176824.727318.31260@g44g2000cwa.googlegroups.com...
    > Hi Friends
    > I want to format those Cells which contains any error. I have tried in
    > conditional formatting with as Formula is =ISERROR, but it is not
    > working. can any one help on this
    >
    > Thank you
    >




  6. #6
    Bob Phillips
    Guest

    Re: conditional formatting for Error

    Select your cells and use the cell referen ce of the first, such as

    =ISERROR(A2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "krupesh" <k.bhansali@rediffmail.com> wrote in message
    news:1123176824.727318.31260@g44g2000cwa.googlegroups.com...
    > Hi Friends
    > I want to format those Cells which contains any error. I have tried in
    > conditional formatting with as Formula is =ISERROR, but it is not
    > working. can any one help on this
    >
    > Thank you
    >




  7. #7
    Bob Phillips
    Guest

    Re: conditional formatting for Error

    Select your cells and use the cell referen ce of the first, such as

    =ISERROR(A2)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "krupesh" <k.bhansali@rediffmail.com> wrote in message
    news:1123176824.727318.31260@g44g2000cwa.googlegroups.com...
    > Hi Friends
    > I want to format those Cells which contains any error. I have tried in
    > conditional formatting with as Formula is =ISERROR, but it is not
    > working. can any one help on this
    >
    > Thank you
    >




+ 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