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