checking for same data

[ROLG]

i have the azimuth of the sun for each hour of one day in the sam
cell .
there is 365 cells all in one column. (365 days in a year) the angl
of the sun
repetes it self through the year. is there a way that i can find an
distinguish
all cells with the same data? say turn them all green or red?
thankyo

 

[JulieD]

Hi

Have a look at Chip Pearson's website - he has notes there on highlighting
duplicate entries

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

Cheers
JulieD

 

[Myrna Larson]

Do you mean that you have 24 values in a single cell?

 

[ROLG]

the number of entries in each cell equalls the number of daylite hours

 

[JulieD]

Hi

when you say that you want to find and distinguish all cells with the same
data do you mean the entire contents of one cell matching the entire
contents of another cell or are we talking about an entry in a cell matching
an entry in another cell?

how is the data in each cell separated?

Cheers
JulieD

 

[Myrna Larson]

Doesn't sound like an optimal layout for processing UNLESS you want all 24
numbers in one cell to match all 24 in another cell.

 

[ROLG]

i want to choose any cell (in the list of 365 cells) and find out whic
of the other 364 cells have the exact same data. all cells are in th
same column. there will be
quite a few exact copies of most of the cells .
sorry for not being ver
clear

 

[JulieD]

Hi

probably the easiest way to do this is via conditional formatting ... choose
a "compare" cell (a blank cell which you're going to use to inidicate what
you want highlighted)

now select your list and choose format / conditional formatting
choose
cell value is
equal to
and click on the "compare cell" (e.g. G1)
now click format - set your options.
click OK twice

when you want to find out what days match another day, copy the contents of
the first day to the "compare" cell and the the values matching this will be
formatted as you selected.

hope this helps
Cheers
JulieD