Ah, you can get the whole row (or parts of the row to highlight):
Select say A2:L99 (with A2 the active cell).
Then format|Conditional formatting.
Use a formula that refers to the cell in column A of that row:
=TEXT($A2,"yyyymm")=TEXT($A$1,"yyyymm")
This will use the date value in A1 and compare it to the date in A2:A99. If the
year and month match, then A:L (of that row) will be formatted.
(I was confused over what cell you were using to compare all dates to.)
Andrew Clark wrote:
Dave Peterson wrote in
:
Have you thought of using Format|Conditional formatting?
You get up to 3 formats (plus the normal one)?
It might be simpler and less work for excel to do.
Andrew Clark wrote:
I would, but I want to highlight the entire row, not just that cell.
--
Dave Peterson
|