Conditional Format to highlight entire row if a condition is met
I have a worksheet that has 25 colums. In column R I have a particular date
ie..01/01/2008, I need to have the entire row highlighted if column R falls between 01/01/2008 and 01/31/2008. Can you please provide some guidance. Thanks Karen |
Conditional Format to highlight entire row if a condition is met
Use a CF formula of
=AND($R1=--"2008-01-01",$R1<--"2008-01-31") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "klmiura" wrote in message ... I have a worksheet that has 25 colums. In column R I have a particular date ie..01/01/2008, I need to have the entire row highlighted if column R falls between 01/01/2008 and 01/31/2008. Can you please provide some guidance. Thanks Karen |
Conditional Format to highlight entire row if a condition is met
Pick a cell in the row and:
Format Condtional formatting... FormulaIs: =AND(($R139449),($R1<39479)) Copy this formatting across the entire row. Then attack the other rows. -- Gary''s Student - gsnu200758 "klmiura" wrote: I have a worksheet that has 25 colums. In column R I have a particular date ie..01/01/2008, I need to have the entire row highlighted if column R falls between 01/01/2008 and 01/31/2008. Can you please provide some guidance. Thanks Karen |
Conditional Format to highlight entire row if a condition is m
I need this to look for a date(Column R) between the dates(Nov 1-Nov30) in
the entire Column of R and highlight the entire row, I wrote this formula and it did nothing: =AND($R:$R=--"2007-11-01",$R:$R<=--"2007-11-30") What am I missing? Karen "Bob Phillips" wrote: Use a CF formula of =AND($R1=--"2008-01-01",$R1<--"2008-01-31") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "klmiura" wrote in message ... I have a worksheet that has 25 colums. In column R I have a particular date ie..01/01/2008, I need to have the entire row highlighted if column R falls between 01/01/2008 and 01/31/2008. Can you please provide some guidance. Thanks Karen |
Conditional Format to highlight entire row if a condition is m
This did not work.
"Gary''s Student" wrote: Pick a cell in the row and: Format Condtional formatting... FormulaIs: =AND(($R139449),($R1<39479)) Copy this formatting across the entire row. Then attack the other rows. -- Gary''s Student - gsnu200758 "klmiura" wrote: I have a worksheet that has 25 colums. In column R I have a particular date ie..01/01/2008, I need to have the entire row highlighted if column R falls between 01/01/2008 and 01/31/2008. Can you please provide some guidance. Thanks Karen |
Conditional Format to highlight entire row if a condition is m
You select all the relevant rows starting at 1, and then use the formula I
gave. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "klmiura" wrote in message ... I need this to look for a date(Column R) between the dates(Nov 1-Nov30) in the entire Column of R and highlight the entire row, I wrote this formula and it did nothing: =AND($R:$R=--"2007-11-01",$R:$R<=--"2007-11-30") What am I missing? Karen "Bob Phillips" wrote: Use a CF formula of =AND($R1=--"2008-01-01",$R1<--"2008-01-31") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "klmiura" wrote in message ... I have a worksheet that has 25 colums. In column R I have a particular date ie..01/01/2008, I need to have the entire row highlighted if column R falls between 01/01/2008 and 01/31/2008. Can you please provide some guidance. Thanks Karen |
All times are GMT +1. The time now is 05:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com