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
|