formula help needed

[starchie]

hi

this is my first post here, so hello all and i hope you can help me
and in time i can help others

my problem is:

i want to write a formula so that if a cell in a coloum contains the
same numeric value as a previous cell, that the newest version of the
numerical value is highlighted, so it alerts me that the number has
already been selected by some one else

this is to be used in a sweepstake type application for the touring
television crew on a sporting event, where we try to estimate the
number of runs scored on any particulr day, and keeping trackof 70 or
so csores on a pda involves much scrolling up and down

i have tried the conditional formating formula

if the cell value is equal to =b2+b75 format text red

using the conditional formatting wizard in the format drop down menu,
but it colours the previous instance red instead of the new instance

has this made any sense to anyone? is there an answer and will it work
on a pda - it would make my mornigs a lot less fraught as i collect
peoples estimates


peace and love


starchie

 

[WillR]

Here's a good link for using Conditional formatting/data validation t
prevent or highlight duplicate entries in a list

'Prevent Duplicates' (http://www.ozgrid.com/Excel/Formulas.htm)

Hope it helps,

Wil

 

[Debra Dalgleish]

To highlight a number that's been used previously:

Select the cells to be formatted, e.g. B2:B75
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell:
=COUNTIF($B$1:B1,B2)
Click the Format button, and on the Patterns tab, select a colour
Click OK, click OK

The following MSKB article says there may be some problems with
conditional formatting, but you could try it on your version:

Problems When You Convert Files Between Excel and Pocket Excel
http://support.microsoft.com/default.aspx?id=185921

 

[starchie]

hi


thanks for the quick replies

i shall try to apply them and let you know the outcome

peace and love

starchie

 

[starchie]

hi debra

it worked like a dream

now to test it on pocket excel.....


peace and love

starchie