Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|