Help please

[brogart28]

Im in a bit of a bind so if anyone can help me plz!!!


The problem is that I have begun a new database and i want information in one cell that appears again later down the line in the same row to be highlighted. Can this be done?

Please get back to me ASAP!!!

Thank you

[S3NTYN3L]

Let's say the data in cell A1 is needed in cell D1...

In cell D1 you would type: =A1

Then, with cell D1 still active, click Format > Conditional Formatting...
Set things up as:
Cell Value Is: Greater Than 0

Click "Format" and set up your text color or patterns...

Hope this helps...

[S3NTYN3L]

Sorry, Double Post...

[brogart28]

Thanks for your help but its not working.

See all my information is based between cells C3 through to C11. Its based on registration numbers and I want cells to highlight if by any chance the same registration shows up more then once

[pinmaster]

Use conditional Formatting.

Select your data then go to Format/Conditional Formatting.

condition 1 - select "formula is" and type:

=COUNTIF($A1:$F1,A1)>1
click on Format and format as desired.

HTH
JG

"brogart28" wrote:

>
> Im in a bit of a bind so if anyone can help me plz!!!
>
>
> The problem is that I have begun a new database and i want information
> in one cell that appears again later down the line in the same row to
> be highlighted. Can this be done?
>
> Please get back to me ASAP!!!
>
> Thank you
>
>
> --
> brogart28
> ------------------------------------------------------------------------
> brogart28's Profile: http://www.excelforum.com/member.php...o&userid=30867
> View this thread: http://www.excelforum.com/showthread...hreadid=505474
>
>

[pinmaster]

Use conditional Formatting.

Select your data then go to Format/Conditional Formatting.

condition 1 - select "formula is" and type:

=COUNTIF($A1:$F1,A1)>1
click on Format and format as desired.

HTH
JG

"brogart28" wrote:

>
> Im in a bit of a bind so if anyone can help me plz!!!
>
>
> The problem is that I have begun a new database and i want information
> in one cell that appears again later down the line in the same row to
> be highlighted. Can this be done?
>
> Please get back to me ASAP!!!
>
> Thank you
>
>
> --
> brogart28
> ------------------------------------------------------------------------
> brogart28's Profile: http://www.excelforum.com/member.php...o&userid=30867
> View this thread: http://www.excelforum.com/showthread...hreadid=505474
>
>

[brogart28]

Thank you for your help