conditonal formating

  • Thread starter Thread starter Zoef
  • Start date Start date
Z

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