| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Background changes conditionally
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 |
| 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 | |||
Threaded Mode
