conditonal formating

[Zoef]

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

 

[JE McGimpsey]

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).

 

[Peo Sjoblom]

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)

 

[Gord Dibben]

Zoef

For entire rows, select the rows, not cells.

For parts of rows, select the cells

Format>Cells>CF>Formula 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 Format>Patterns

For more on this see Debra Dalgleish's site at

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

Gord Dibben Excel MVP