Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Conditional format numbers | Excel Worksheet Functions | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Conditional format of minimum number | Excel Worksheet Functions | |||
Conditional Format Question | Excel Worksheet Functions |