If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditonal formating
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 |
#2
|
|||
|
|||
conditonal formating
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 |
#3
|
|||
|
|||
conditonal formating
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) -- Regards, Peo Sjoblom "Zoef" wrote in message ... 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 |
#4
|
|||
|
|||
conditonal formating
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 |
Thread Tools | |
Display Modes | |
|
|