Conditional Formatting with multiple references

[mirzaindmajor]

Hi all,

I am working in a receiving room at a condo complex and am trying to facilitate how we handle and distribute the packages.

What I have in the first sheet of my would-be file is the unit numbers in a 28X12 array (12 units on 28 floors). I would like to make the array conditionally formatted to be highlighted in red to show that there is a package in for the unit in question. On the next sheet, I am putting information such as carrier, unit number and tracking number for each of the packages we receive. I want the unit number on the first sheet to immediately be red when the unit number is typed in the second sheet. When doing conditional formatting, it is easy to do this, by making the condition that the unit in the array will be highlighted when the unit is seen in the unit column in the second sheet.

My question is this: is it possible to somehow duplicate the references for the entire column that contains the unit numbers. It would be an extremely boring and time consuming process to take this one one cell at a time, so it would be great if there were a way for this to be done quickly.

If that didn't make sense, I want a whole column to be the reference for conditional formatting of an array, so that I would be easily able to see who has a package in the receiving room, and who does not.

Please let me know if there is any way I can clarify my request or if there is any further information you may need.

Thanks!

 

[etaf]

Please would you show an example of your workbook to the forum - perhaps using a file share website

Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mockup of the expected results you want to achieve.


As i'm not 100% certain what you are trying to duplicate here