Help please

B

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 informatio
in one cell that appears again later down the line in the same row t
be highlighted. Can this be done?

Please get back to me ASAP!!!

Thank yo
 
S

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...
 
B

brogart28

Thanks for your help but its not working.

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

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
 
P

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
 
Top