View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Excel 2003 Conditional formatting challenge question

why haven't you used solutions provided to your post of 05:15 in the
NG?

was there anything wrong with them?


On 9 Lis, 14:10, 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