Hi,

I am trying to highlight resource in column A starting cell A2. Here I will list resources and many will come more than once. This resource shall be shown as booking in time slots starting column B2. Such slots can be many (~300). Booking is shown by marking a x in corresponding cell.
If a resource comes more than once, and it  has same slot more than once, then this resouce needs to be highlighted.
Example data is below:

ResourceSlot-1Slot-2Slot-3Slot-4Slot-5Slot-6Slot-7Slot-8Slot-9Slot-10Slot-11Slot-12Slot-13M-1xx           M-2 xx          M-2   xx        M-3 xxxxx       M-4      x      M-3xx           M-4  xxx xx     

In this case, resource M-3 cell will be highlighted.
So conditional formatting shall be in Column A.
Pls help with suitable formula, 

​Hi, I am trying to highlight resource in column A starting cell A2. Here I will list resources and many will come more than once. This resource shall be shown as booking in time slots starting column B2. Such slots can be many (~300). Booking is shown by marking a x in corresponding cell.If a resource comes more than once, and it  has same slot more than once, then this resouce needs to be highlighted.Example data is below:ResourceSlot-1Slot-2Slot-3Slot-4Slot-5Slot-6Slot-7Slot-8Slot-9Slot-10Slot-11Slot-12Slot-13M-1xx           M-2 xx          M-2   xx        M-3 xxxxx       M-4      x      M-3xx           M-4  xxx xx      In this case, resource M-3 cell will be highlighted.So conditional formatting shall be in Column A.Pls help with suitable formula,   Read More

​