You can certainly conditionally format based on other cells.

Assuming your dates are in A1:A366, select rows 1:366, with Row 1 active

Choose Format/Conditional Formatting...

Use the dropdowns and textboxes to enter

Formula is =$A1=TODAY()

and choose your highlighting. XL will adjust the rows (but not the
column, since the $ makes it absolute).





In article ,
"Zoef" wrote:

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