software

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: www.excelforum.com/member.php...oamp;userid=30867
View this thread: www.excelforum.com/showthread...hreadid=505474
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 gt; Conditional
Formatting...
Set things up as:
Cell Value Is: Greater Than 0

Click quot;Formatquot; and set up your text color or patterns...

Hope this helps...--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: www.excelforum.com/member.php...oamp;userid=30247
View this thread: www.excelforum.com/showthread...hreadid=505474
Sorry, Double Post...--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: www.excelforum.com/member.php...oamp;userid=30247
View this thread: www.excelforum.com/showthread...hreadid=505474
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--
brogart28
------------------------------------------------------------------------
brogart28's Profile: www.excelforum.com/member.php...oamp;userid=30867
View this thread: www.excelforum.com/showthread...hreadid=505474
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--
brogart28
------------------------------------------------------------------------
brogart28's Profile: www.excelforum.com/member.php...oamp;userid=30867
View this thread: www.excelforum.com/showthread...hreadid=505474Use conditional Formatting.

Select your data then go to Format/Conditional Formatting.

condition 1 - select quot;formula isquot; and type:

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

HTH
JG

quot;brogart28quot; wrote:

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


Thank you for your help--
brogart28
------------------------------------------------------------------------
brogart28's Profile: www.excelforum.com/member.php...oamp;userid=30867
View this thread: www.excelforum.com/showthread...hreadid=505474