Hi,
assuming that your data sheet has the desk number in B1 and the subnet
number is in E1

conditional format your desk colour =E1=162 (format 1 colour) =E1=167
(format second colour)

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=381545