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
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
Hi Nigel,
Formula Is : = OR($A$1="A",$A$1="P")
Regards,
Peter T
"Nigel" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
>
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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks