The next version of XL will permit you all you want, but until then, check
out this link:

http://www.xldynamic.com/source/xld.....Download.html


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"das1997" wrote in message
...
Im trying to set a sheet of fixed numbers (120) and need to have the chart
highlight the numbers that match the five random numbers selected.
Conditional formatting would work if it would let me use 5 rules but it
only
lets me use up to 3. I'm trying to highlight all the chart and then make
rules to highlight in orange if any cell in the chart matches the numbers
I
input in each if the 5 cells at the top of the page. Any suggestions?
Thanks David