Can merged cells fill, when matched in a column??

[HockeyDiablo]

Hello, I am trying to make a floor plan and wanted the booth squares to turn red, if they are matched with the same booth number located in B2:B22.

 

[mumps]

First of all, you should avoid merging cells because they almost always cause problems for macros. In any case, it is hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or ww.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Joe4]

Yes, you can use Conditional Formatting.

Do the following:
1. Select the range C2:J34
2. Click on Conditional Formatting
3. Select "New Rule"
4. Select the "Use a formula to determine which cells to format" option
5. Enter the following formula:

=COUNTIF($A$3:$A$24,C2)>0

6. Click on the "Format" button
7. Go to the "Fill" tab and select the red color
8. Click "OK" twice

Here is a simplified example of your case I just did: