Hi Domenic,

Conditional Formatting help very much appreciated.

Domenic wrote:
By the way, when defining named ranges or references, array formulas
don't need to be confirmed with CONTROL+SHIFT+ENTER.

Just to clarify: do you mean the shorter version of the Formula in B2 does
not have to be array entered?

Note: In the interest of making the formula for B2 shorter and somewhat
more efficient, I tried to define references for both LARGE functions.
I was hoping to be able to do something like this...

=IF($A2<$B$1,<FirstLargeReference-<SecondLargeReference-1,"")

Cheers
Sam

Domenic wrote:
Thank you ever so much for all your great help.

You're very welcome, Sam!

defined both LARGE Function references as suggested using their respective
LARGE syntax in the Names Refers To Box and used the shorter Defined Names in
cell B2 - it worked whether they were array entered or not - calculating all
Intervals correctly.

Great! I had a feeling it would work for you. I don't understand why
it doesn't work on my Mac version, though. There doesn't seem to be any
reason why it shouldn't. Oh well...

By the way, when defining named ranges or references, array formulas
don't need to be confirmed with CONTROL+SHIFT+ENTER.

Use conditional formatting to hide #NUM! error values that will
result when no other intervals exist. If you need help with this, post
back.

Would appreciate your assistance.

1) Select B2

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=ISERR(B2)

4) Choose 'White' as your font colour

5) Click Ok

Hope this helps!


--
Message posted via http://www.officekb.com