+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting

  1. #1
    Nigel
    Guest

    Conditional Formatting

    Hi All

    A simple one but it has me stumped!

    I wish to set up a Conditional Format for a cell that has either a letter
    "A" or "P" in it.

    I used the following
    Cell Value Is
    Is Equal to
    =OR("A","P")

    without success !!
    Help Please

    --
    Cheers
    Nigel





  2. #2
    Peter T
    Guest

    Re: Conditional Formatting

    Hi Nigel,

    Formula Is : = OR($A$1="A",$A$1="P")

    Regards,
    Peter T


    "Nigel" <nigel-sw@suxnospampanet.com> wrote in message
    news:OTaH904EGHA.3920@TK2MSFTNGP09.phx.gbl...
    > Hi All
    >
    > A simple one but it has me stumped!
    >
    > I wish to set up a Conditional Format for a cell that has either a letter
    > "A" or "P" in it.
    >
    > I used the following
    > Cell Value Is
    > Is Equal to
    > =OR("A","P")
    >
    > without success !!
    > Help Please
    >
    > --
    > Cheers
    > Nigel
    >
    >
    >
    >




  3. #3
    Barb Reinhardt
    Guest

    Re: Conditional Formatting

    Try this

    Select the cells that you want to conditionally format. The first cell I
    selected was A4, so you'll need to change this to suit your circumstances

    =OR(A4="A",A4="P")

    "Nigel" <nigel-sw@suxnospampanet.com> wrote in message
    news:OTaH904EGHA.3920@TK2MSFTNGP09.phx.gbl...
    > Hi All
    >
    > A simple one but it has me stumped!
    >
    > I wish to set up a Conditional Format for a cell that has either a letter
    > "A" or "P" in it.
    >
    > I used the following
    > Cell Value Is
    > Is Equal to
    > =OR("A","P")
    >
    > without success !!
    > Help Please
    >
    > --
    > Cheers
    > Nigel
    >
    >
    >
    >




+ 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