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