View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wynand wynand is offline
external usenet poster
 
Posts: 54
Default conditional formatting- same value, different columns

Can anyone please assist:
data is in A2:J2000
I want to highlight identical values in different cells
I used the formula =COUNTIF($A$2:$A$183,D559)1
with no results?