View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ju
 
Posts: n/a
Default 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