Help with Conditional Format Formula
=COUNTIF(INDIRECT("Sheet2"&"!A:A"),A1)<1
"David K." wrote:
Hi,
How can I highlight cells in a list of numbers on Sheet1 where the number of
occurrences of that number on Sheet2 is not equal to 1?
Sheet1 has a list of unique numbers that will not change.
Sheet2 is an entry sheet were a list will be entered.
Assuming both lists will start in A1 and continue in column A.
On Sheet1 how can I highlight cells in the list where the number of
occurrences of that number on Sheet2 is not equal to 1?
In other words, using the list on Sheet1, I want to know if a number has not
been entered or entered more than once on Sheet2.
Hope this makes sense to someone. Thanks for any ideas.
--
David K.
.
|