Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |