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