View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dickery Dickery is offline
external usenet poster
 
Posts: 1
Default mark unrepeated cells

Hello
I have a spreadsheet with many rows and cols of numbers.
1 2 3 4 5 5 6 6 7 7 8 8 67 5 4 4 3 4 3 545 6 6 7 7
7 8 8 67 5 4 4 3 4 3 545 6 6 7 7 3 3 3 4 5 6 4 3
.......

I want to do a mark the cells red if the specific value does not exist
in the previous 3 rows. Can this be done. If so pl give some ways of
doing it.

Thanks

Seede