Conditional formatting of 5 cells

[Jeff Manning]

Is it possible to use conditional formatting to highlight cells 5,6,7,8,9 and 10 out of, say 20 cells?
I am using
=D5>=LARGE($D5:$W5,10)
for highliting when 10 cells are filled but I want to get highliting on the 5th cell to be filled to the 10th.
There is not enough conditional formatting entries available to do all this, can it be done by changing the formula above?
Thanks
Jeff

[Domenic]

Try the following...

=(D5>=LARGE($D5:$W5,10))*(D5<=LARGE($D5:$W5,5))

Hope this helps!

Is it possible to use conditional formatting to highlight cells 5,6,7,8,9 and 10 out of, say 20 cells?
I am using
=D5>=LARGE($D5:$W5,10)
for highliting when 10 cells are filled but I want to get highliting on the 5th cell to be filled to the 10th.
There is not enough conditional formatting entries available to do all this, can it be done by changing the formula above?
Thanks
Jeff

[Domenic]

Try the following instead...

1) Select your data

2) Format > Conditional Formatting > Formula Is

3) Enter the following formula:

=(D5<>"")*(COUNT($D5:$W5)>=5)*(D5>=LARGE($D5:$W5,MIN(10,COUNT($D5:$W5))))

4) Choose your formatting

5) Click OK

Hope this helps!

Try the following...

=(D5>=LARGE($D5:$W5,10))*(D5<=LARGE($D5:$W5,5))

Hope this helps!

[Jeff Manning]

That formula worked just great Domenic, thanks for your help with these problems I have been having - you have saved me a lot of head scratching time (I still would not have got there by myself though, but I am learning as I go along)!
Best regards
Jeff