conditional formatting dilemma!

[cosmic_seahorse]

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

 

[Andrew Poulsom]

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]

Hi Andrew,

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