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

Harold,

If appears that your current waist and hip values are available in range names. If so, then
you could use conditional formatting with your formula. The conditional formula must be
applied to all the cells of your hip/waist table, and you have to structure a formula that
resolves to TRUE or FALSE for that to work, I'm not sure what your LastWaist() and
LastHip() do. If you want some help, give your formula, and the actual rows and columns of
your waist/hip table.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
wrote in message
ups.com...
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

On Aug 24, 10:00 am, "Earl Kiosterud" wrote:
Harold,

If appears that your current waist and hip values are available in range names. If so, then
you could use conditional formatting with your formula. The conditional formula must be
applied to all the cells of your hip/waist table, and you have to structure a formula that
resolves to TRUE or FALSE for that to work, I'm not sure what your LastWaist() and
LastHip() do. If you want some help, give your formula, and the actual rows and columns of
your waist/hip table.
--
Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -

Thanks for your reply! Unfortunately, I already have 3 conditional
formats set in each table cell for results of red, yellow and blue
based on the ratio number (Bad, Fair and Excellent). The upper left
cell of the range has the formula =$A16/B$15 where a16 is the
waist(1st column of the range) and B15 is hip(1st rowof the range).
The formula in the cell directly to the right of the first is =$A16/C
$15. As you pointed out, =LastWaist and =LastHip are range names. You
can think of them as constants for our purpose.

What do you think?

On Aug 24, 1:24 pm, wrote:
On Aug 24, 10:00 am, "Earl Kiosterud" wrote:





Harold,

If appears that your current waist and hip values are available in range names. If so, then
you could use conditional formatting with your formula. The conditional formula must be
applied to all the cells of your hip/waist table, and you have to structure a formula that
resolves to TRUE or FALSE for that to work, I'm not sure what your LastWaist() and
LastHip() do. If you want some help, give your formula, and the actual rows and columns of
your waist/hip table.
--
Earl Kiosterudwww.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
wrote in message

oups.com...

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- Hide quoted text -

- Show quoted text -

Thanks for your reply! Unfortunately, I already have 3 conditional
formats set in each table cell for results of red, yellow and blue
based on the ratio number (Bad, Fair and Excellent). The upper left
cell of the range has the formula =$A16/B$15 where a16 is the
waist(1st column of the range) and B15 is hip(1st rowof the range).
The formula in the cell directly to the right of the first is =$A16/C
$15. As you pointed out, =LastWaist and =LastHip are range names. You
can think of them as constants for our purpose.

What do you think?- Hide quoted text -

- Show quoted text -

*EDIT* To make things a little clearer, when I enter a new waist and
hip measurements in my spreadsheet, LastWaist() and LastHip() will
have the latest values. What I want to happen is the the row matching
my last waist and the column matching my lasthip to find the
interesection of the row and column, and bold the intersecting cell.