OR or conditional format
 

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(INDIR ECT("$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

OR or conditional format
 

How about

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ju" wrote in message
...
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(INDIR ECT("$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

OR or conditional format
 

Ah! thanks Bob.

Ju


How about

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ju" wrote in message
...
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(INDIR ECT("$d"&ROW()),0,-2)="PH"
)

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

OR or conditional format
 

It's often easier than we think <bg

Bob

"Ju" wrote in message
...

Ah! thanks Bob.

Ju


How about

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ju" wrote in message
...
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(INDIR ECT("$d"&ROW()),0,-2)="PH"
)

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