have done conditional formatting with the following formula
but it only seems to update the text as the column has text and numbers, but it ignores the numbers any ideas![]()
=COUNTIF($G$2:$G$154,G2)>3
formating is on the PC List sheet
have done conditional formatting with the following formula
but it only seems to update the text as the column has text and numbers, but it ignores the numbers any ideas![]()
=COUNTIF($G$2:$G$154,G2)>3
formating is on the PC List sheet
figured out was my own silly fault see code below
![]()
=COUNTIF($G$2:$G$154,$G2)>2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks