Excel 2007 : Highlighting a Row with a Certain Date

**Ormond2009** · 03-29-2010, 01:33 PM

I am trying to use conditional formatting to call attention to a row that contains the current date. I can easily highlight a cell containing the date, but is there an easy way to highlight the entire row, and not just the cell?

Would it be easier to use a macro? I also know that I can sort my table and manually highlight the rows, but I don't want to have to sort the table each time.

Thank you for your help!

**zbor** · 03-29-2010, 01:44 PM

As you make conditional formating for a cell make same for a row.

Only select whole row (or cells you like to highlight) and Write =$B1=TODAY() where B1 is your date you comparing.

**Ormond2009** · 03-29-2010, 02:14 PM

Originally Posted by zbor

As you make conditional formating for a cell make same for a row.

Only select whole row (or cells you like to highlight) and Write =$B1=TODAY() where B1 is your date you comparing.

I am not sure that I follow your answer. Am I supposed to use a formatting rule based upon your formula?

I am selecting the entire range of my table...
I will try some more. Thank you for your quick response!

**zbor** · 03-29-2010, 02:24 PM

Look example:

**Marcol** · 03-29-2010, 02:25 PM

Is there any other data in the row you want to highlight?

If so that data could well affect the result, ie punch holes in the highlighted row,and leave cells highlighted when the condition is not met.
In this case a simple solution might not be possible without a macro

EDIT:

Hold that result! zbor is bang on.
Clean forgot about the fomula option. Silly boy!

**Ormond2009** · 03-29-2010, 02:59 PM

Originally Posted by zbor

As you make conditional formating for a cell make same for a row.

Only select whole row (or cells you like to highlight) and Write =$B1=TODAY() where B1 is your date you comparing.

Thank you Zbor. I didn't realize that $B1 was the column containing the date. Your spreadsheet example cleared up my confusion. I can use the DATE function (instead of NOW) to specify a different date too.

Thanks again to all!!!