conditonal formating
How large is your calendar? Assume for simplicity it is A2:L32,
select the date part of the calendar with A2 as the active cell use formula
is and
=ISNUMBER(MATCH(TODAY(),$A2:$L2,0))
note that if the date part is A2:L32 then you have to select that range
starting with A2 (that would
make it the active cell)
--
Regards,
Peo Sjoblom
"Zoef" wrote in message
...
hi,
I have a sheet like a calendar and I would like to highlight the row
coresponding of the current date.
I only manage to highlight the date itself with conditional formating
(cell - equal to - =TODAY() )
but I can't highlight the rest of the row, since conditional formating of
a
cell work only with the value of the cell itself (no reference to other
cell
seems possible)
any solution ?
thanks
|