Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format cells semi automatic
I was wondering if it would be possible to format cells semi automatic. See attached picture for example. I have a standard workbook to help collegues completing a bending schedule with automatic calculation. Within the sheet shape codes are being inserted (number between 20 - 99); each shape code needs certain cells to be updated with a user difined value. Is it possible with a vlookup fuction or similar to let excel format the cell color as shown in the example. The sheet is functioning fine; the only worry is that most cells/calculation will give a result even if a cell value is left out (by accident). This shading would make it very easy to spot a mistake. PS error code would also be good. W +-------------------------------------------------------------------+ |Filename: immage 2.jpg | |Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=143| +-------------------------------------------------------------------+ -- willemeulen Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands) ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98426 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export Excel in a semi-colon delimited format? | Excel Discussion (Misc queries) | |||
Automatic Format for Table | Excel Discussion (Misc queries) | |||
Automatic axis format | Charts and Charting in Excel | |||
.CSV file format - comma or semi-colon? | Excel Worksheet Functions | |||
.CSV file format - comma or semi-colon | Excel Worksheet Functions |