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