OR or conditional format

[Ju]

May i know what is wrong with this?

What i am trying to do is to colour the whole row if the date at column
d is a sunday or a public holiday.

I put the following formula in the conditional format, but it doesnt
colour the row.

=OR(WEEKDAY(INDIRECT("$D"&ROW()),2)=7,OFFSET(INDIRECT("$d"&ROW()),0,-2)="PH")

data is as follows:
column A B C D
Row1 Sunday 06-11-2005
Row2 PH 03-11-2005


Appreciate some help on this. Thx

Ju

[Bob Phillips]

How about

=OR(WEEKDAY($D2)=1,$B2="PH")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ju" <this@isnot.correct> wrote in message
news:dnp8v6$fh4$1@mawar.singnet.com.sg...
> May i know what is wrong with this?
>
> What i am trying to do is to colour the whole row if the date at column
> d is a sunday or a public holiday.
>
> I put the following formula in the conditional format, but it doesnt
> colour the row.
>
>
=OR(WEEKDAY(INDIRECT("$D"&ROW()),2)=7,OFFSET(INDIRECT("$d"&ROW()),0,-2)="PH"
)
>
> data is as follows:
> column A B C D
> Row1 Sunday 06-11-2005
> Row2 PH 03-11-2005
>
>
> Appreciate some help on this. Thx
>
> Ju
>
>
>
>
>
>
>
>
>

[Ju]

Ah! thanks Bob.

Ju


How about

=OR(WEEKDAY($D2)=1,$B2="PH")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ju" <this@isnot.correct> wrote in message
news:dnp8v6$fh4$1@mawar.singnet.com.sg...
> May i know what is wrong with this?
>
> What i am trying to do is to colour the whole row if the date at column
> d is a sunday or a public holiday.
>
> I put the following formula in the conditional format, but it doesnt
> colour the row.
>
>
=OR(WEEKDAY(INDIRECT("$D"&ROW()),2)=7,OFFSET(INDIRECT("$d"&ROW()),0,-2)="PH"
)
>
> data is as follows:
> column A B C D
> Row1 Sunday 06-11-2005
> Row2 PH 03-11-2005
>

[Bob Phillips]

It's often easier than we think <bg>

Bob

"Ju" <this@isnot.correct> wrote in message
news:dnrno1$88r$1@reader01.singnet.com.sg...
>
> Ah! thanks Bob.
>
> Ju
>
>
> How about
>
> =OR(WEEKDAY($D2)=1,$B2="PH")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Ju" <this@isnot.correct> wrote in message
> news:dnp8v6$fh4$1@mawar.singnet.com.sg...
> > May i know what is wrong with this?
> >
> > What i am trying to do is to colour the whole row if the date at column
> > d is a sunday or a public holiday.
> >
> > I put the following formula in the conditional format, but it doesnt
> > colour the row.
> >
> >
>
=OR(WEEKDAY(INDIRECT("$D"&ROW()),2)=7,OFFSET(INDIRECT("$d"&ROW()),0,-2)="PH"
> )
> >
> > data is as follows:
> > column A B C D
> > Row1 Sunday 06-11-2005
> > Row2 PH 03-11-2005
> >
>
>
>