| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to apply the same background to many sheets simultaneously. | Excel Worksheet Functions | |||
| how do you get rid of the default background of "page 1" in excel | Excel Discussion (Misc queries) | |||
| Form-filling application with Excel (background image)? | Excel Discussion (Misc queries) | |||
| Background Picture OR text over a picture | Excel Discussion (Misc queries) | |||
| Photo for background takes a lot of space (MB) | Setting up and Configuration of Excel | |||
Hybrid Mode
