As I scroll through a list of order numbers, I want to know if that text value in the active cell is present in any one of three ranges (call them Joe, Jack, Jim). I don't need to know which range, or where in the range, or return any value except 'true' or 'false'. That value will control a conditional format in a frozen header line at the top of the chart. ("Confirmed" will become visible if the number is present in a salesman's range.) How do I do this such that it will update as I scroll even if I don't change anything?
Thanks for your help.
David
Thanks for your help.
David