Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a little more help with formatting!
First of all I want to say thanks to Tom for helping me out. I am working with what was given to me but I still can't get it to work like I want. Location Device 1 Fail Comments & Notes Location Device 2 Fail Comments & Notes Location Device 1 Pass Comments & Notes Location Device 3 Fail Comments & Notes Location Device 4 Fail Comments & Notes Location Device 4 Pass Comments & Notes Location Device 3 Pass Comments & Notes Location Device 8 Fail Comments & Notes Location Device 8 Pass Comments & Notes Location Device 1 Fail Comments & Notes Exactly what I need to do is to make it so that when I enter a "Device # Fail" then it turns bold. I also think that I need to create an array with the different device types and declare all the types in the array. The next thing I need to do is to have excel see the bold failed device and then copy the entire row that it is in to another sheet. I have about 15 different device types and am able to only get one device to become bold. I still have not gotten to work on copying rows to another sheet so any help would be appreciated. I will keep working with what I have and what I know. -- hawaiian_native ------------------------------------------------------------------------ hawaiian_native's Profile: http://www.excelforum.com/member.php...o&userid=26351 View this thread: http://www.excelforum.com/showthread...hreadid=397220 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |