I like what you did with formulas instead of a Pivot Table.
What I was trying to do with the conditional formatting was to
show the maximum for both row and for column using the
3 conditional formats available:
http://www.mvps.org/dmcritchie/excel/condfmt.htm#tables
for the dimension that you are least interested in, perhaps
a much lighter color.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Eagle784" wrote in message
...
Thanks, but I ended up doing the following:
Log-In list is in column A (e.g A2:A8), organize your sheet as follows:
Cell C1: "Hour"; Cell D1: 7/1/2005; Cell E1: 7/2/2005; ...; Cell AH:
7/31/2005
Cell C2: "0:00"; Cell C3: "1:00"; ...; Cell C25: "23:00": format C2:C25
as "h:mm"
Cell D2:
"=SUMPRODUCT(--(DAY($A$2:$A$8)=DAY(D$1)),--(TIME(HOUR($A$2:$A$8),MINUTE($A$2:$A$8),0)=$C2),--(TIME(HOUR($A$2:$A$8),MINUTE($A$2:$A$8
),0)<=TIME(HOUR($C2),59,59)))"
Copy Cell D2 - Paste Range D2:AH25
select Range D2:AH25 (with Cell D2 active cell) and click Format-
Conditional Format: Select "Formula Is" and enter the following
formula:
"=(D2=MAX(D$2:D$25))"
It worked great.
Thanks for your reply, though
--
Eagle784
------------------------------------------------------------------------
Eagle784's Profile: http://www.excelforum.com/member.php...o&userid=24261
View this thread: http://www.excelforum.com/showthread...hreadid=396973