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?