need a conditional formula can be make the cell become red when A:A having the same no.
It can prevent we key the no repeated.
Thanks.
need a conditional formula can be make the cell become red when A:A having the same no.
It can prevent we key the no repeated.
Thanks.
Let's say the range starts from A2 to down. So select A2:LastRow, then on conditional format >> formula,
=COUNTIF($A:$A,$A2)>1
format as red.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
this formula can not work, have the single number also become red. anyone help please ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks