LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How To Format Row Column Intersection

Hello group. I have something I've been working on for some time and
I'm stuck. Let me describe the situation.

I track my fitness in a spreadsheet. One measure of fitness is the
waist / hip ratio. This is waist divided by hip. I have a range
showing the ratio with the hip measurement accross the top and the
waist measurements down the side. What I want to do is have the
appropriate cell bolded at the intersection of the current waist and
hip.

I have a formula called =LastWaist() and =LastHIp() that I can use to
MATCH to my range row and columns. When it comes to bolding the
correct cell I haven't found the right syntax. Any ideas?

Example of layout

39 38 37
39 1 .97 .95
38 1.03 1 .97
37 1.05 1.03 1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Intersection of row and column based on input CMWalsh Excel Worksheet Functions 5 June 15th 06 11:21 PM
what is the intersection of a column and a row called? judy Excel Discussion (Misc queries) 2 April 6th 06 01:31 PM
LOOKUP FORMULA INTERSECTION OF A COLUMN AND (TWO) VALUES IN A ROW SID Excel Worksheet Functions 1 February 10th 06 09:37 PM
intersection of row and column a Excel Worksheet Functions 5 April 19th 05 05:01 PM
Finding intersection of row and column (both variable) in table RangerAl Excel Worksheet Functions 8 January 1st 05 01:28 AM


All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"