Help please
 

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

Help please
 

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
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505474

Help please
 

Sorry, Double Post...


--
S3NTYN3L
------------------------------------------------------------------------
S3NTYN3L's Profile: http://www.excelforum.com/member.php...o&userid=30247
View this thread: http://www.excelforum.com/showthread...hreadid=505474

Help please
 

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: http://www.excelforum.com/member.php...o&userid=30867
View this thread: http://www.excelforum.com/showthread...hreadid=505474

Help please
 

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: http://www.excelforum.com/member.php...o&userid=30867
View this thread: http://www.excelforum.com/showthread...hreadid=505474

Help please
 

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

Help please
 

Thank you for your help


--
brogart28
------------------------------------------------------------------------
brogart28's Profile: http://www.excelforum.com/member.php...o&userid=30867
View this thread: http://www.excelforum.com/showthread...hreadid=505474