Hi all,

I have a spreadsheet that shows the floor plan layout of my call
centre.
On each desk, the desk number and identity are displayed. I would like
to colour the background for those pcs that are on the same subnet.

I have a sheet called data - it contains Table Number, Desk Number, PC
ID, IP Address.

How could I get it to change the background colour if the pc is on
subnet 162, and set a different colour for those on subnet 167

any ideas?


--
PeterG
------------------------------------------------------------------------
PeterG's Profile: http://www.excelforum.com/member.php...o&userid=16485
View this thread: http://www.excelforum.com/showthread...hreadid=381545