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]

Ah! thanks Bob.

Ju


How about

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Bob Phillips]

It's often easier than we think <bg>

Bob

Ah! thanks Bob.

Ju


How about

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)


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