Prev: =NameCheck - Monday???
Next: update workbook links over network
From: Huggy on 23 May 2010 23:03
How do you format a cell if the data in the cell contains 1 of several buyers
out of a greater list of buyers.

One column in my spreadsheet contains the buyer for that row. I would like
to format that cell if certain buyers are entered.

eg.
Buyer - column heading
a
b
a
d
c
d

I would like to format the cell that contain a and d. I tried to use "Or"
function. such as OR(C53="a", C53="d") but it did not work.


I have excel 2007.

Thanks
From: Per Jessen on 24 May 2010 02:22
It should work, if you have done it correct.

Did you remember to put an equal sign before your function ?

Suppose you have buyers in C2:C100, select the range and goto conditional
formatting, and insert this formula:

=OR(C2="a", C2="d")

Select the desired format.

Hopes this helps.
....
Per

"Huggy" <Huggy(a)discussions.microsoft.com> skrev i meddelelsen
news:53E696CC-00C4-4178-AFC6-9A0018EC0D2A(a)microsoft.com...
> How do you format a cell if the data in the cell contains 1 of several
> buyers
> out of a greater list of buyers.
>
> One column in my spreadsheet contains the buyer for that row. I would like
> to format that cell if certain buyers are entered.
>
> eg.
> Buyer - column heading
> a
> b
> a
> d
> c
> d
>
> I would like to format the cell that contain a and d. I tried to use "Or"
> function. such as OR(C53="a", C53="d") but it did not work.
>
>
> I have excel 2007.
>
> Thanks

From: Huggy on 24 May 2010 04:25
Thanks, I think it didn't work before because I did not refer to the first
row in the data. It works now.

Thanks for the confirmation.


"Per Jessen" wrote:

> It should work, if you have done it correct.
>
> Did you remember to put an equal sign before your function ?
>
> Suppose you have buyers in C2:C100, select the range and goto conditional
> formatting, and insert this formula:
>
> =OR(C2="a", C2="d")
>
> Select the desired format.
>
> Hopes this helps.
> ....
> Per
>
> "Huggy" <Huggy(a)discussions.microsoft.com> skrev i meddelelsen
> news:53E696CC-00C4-4178-AFC6-9A0018EC0D2A(a)microsoft.com...
> > How do you format a cell if the data in the cell contains 1 of several
> > buyers
> > out of a greater list of buyers.
> >
> > One column in my spreadsheet contains the buyer for that row. I would like
> > to format that cell if certain buyers are entered.
> >
> > eg.
> > Buyer - column heading
> > a
> > b
> > a
> > d
> > c
> > d
> >
> > I would like to format the cell that contain a and d. I tried to use "Or"
> > function. such as OR(C53="a", C53="d") but it did not work.
> >
> >
> > I have excel 2007.
> >
> > Thanks
>
> .
>
 | 
Pages: 1
Prev: =NameCheck - Monday???
Next: update workbook links over network