cosmic_seahorse

New Member
Joined
Oct 23, 2013
Messages
2
Hi,
I was wondering if anybody could help me on here, I have scoured the Internet for solutions but none quite solve my problem.

I use a 2007 excel sheet to book products in and out of work. There are two sheets in the workbook, sheet one for booked in and sheet two for booked out.

As I book products out in sheet 2, it would save so much time if the individual product code would highlight in sheet 1 (so I can delete it).

i have grouped and named the respective columns, but cannot for the life of me figure out a formulae to format the duplicates!

Thanks for reading
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

If your booked in products are in column A and you have a name BookedOut you can use a Conditional Formatting formula like:

=COUNTIF(BookedOut,A1)>0
 

cosmic_seahorse

New Member
Joined
Oct 23, 2013
Messages
2
Hi Andrew,

Thanks for your speedy reply! I will try this at work tomorrow, and hopefully all will go swimmingly!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,875
Messages
5,574,762
Members
412,617
Latest member
mlharris
Top