Zoef

For entire rows, select the rows, not cells.

For parts of rows, select the cells

FormatCellsCFFormula is =$A1=TODAY()

Assumes column A is your date range. If not, adjust the column reference.

NOTE: you must enter as $A so just that column is looked at.

Pick a nice color from FormatPatterns

For more on this see Debra Dalgleish's site at

http://www.contextures.on.ca/xlCondFormat02.html

Gord Dibben Excel MVP

On Sat, 24 Apr 2004 00:38:33 +0200, "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