Create a border around the adjacent cell if a conditon exists.

[Jim123]

I have 50 values in cell “A1” like P200, 925-1, AN110 etc. I would like cell “B1“ to automatically create a border around the entire cell if cell “A1” contains one of 10 pre-selected values. This is all to get a signature box to show on selected rows when the sheet is printed. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I know I can make an if statement in “B1” and then use conditional formatting based on the value in “B1” to create a border around the cell. But is this the simplest way or am I taking the long way around the barn?<o></o>
<o></o>
Thanks for any advice<o></o>

 

[jeffreybrown]

It does seem like a simple way if it is working for you...

Another method would be to create a list of the 10 pre-selected values somewhere an call it _List.

Then in B1 with conditional formatting use =MATCH(A1,_List,0) and set your format as desired.

Don't know if this is better, but it eliminates the If statements.

You could even make the named range dynamic so if you add any value it would automatically be added to the list.

 

[Jim123]

That did save a step thank you