Thread
:
Excel 2003 Conditional formatting challenge question
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Excel 2003 Conditional formatting challenge question
Did you see my post
=a1=max($a$1:$a$8)
copy in range a1:a8
The absolutes restrict the area to look at
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"John C." wrote in message
...
Luke,
Ok, I am a bit green on conditional formatting. When the formula is
"=A1=MAX(A1,A8)", why do I need the "=A1" in front of the "=MAX.."? What
if
I left it out? Also, once I establish the first and second table, do i
then
copy the A1 cell and simply special paste just the format in all of the
cells, and then do the same for the second table?
I saw an example on another site using =$A1=MAX($A1,$A8). How do the $
signs restrict the copy in this case?
Thanks for your assistance.
John
"Luke M" wrote:
Select the first table, A1:C6, with A1 being active cell. CF formula is:
=A1=MAX(A1,A8)
Set format, ok out.
Select second table, A8:C13, with A8 being active cell. CF formula is:
=A8=MAX(A1,A8)
Set format, ok out.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"John C." wrote:
I am familiar with how to find a min and max value in a table and
change the
color of the cell and even the font to bold. However, I am stumped
with this
problem. Let's say that I have data in a table from A1 to C6, and from
A8 to
C13. I want to compare A1 to A8, A2 to A9....C6 to C13, and highlight
the
maximum one for each comparison, so that I am comparing apples to
apples.
Will someone please explain how to do this? Thanks for your
consideration.
John
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett