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