Hello - - I have a file that I would like to apply some conditional formating to but when I do, it removes any other formats. I've dummied up a file and attached it. You'll see that colummn F is Blue and M is yellow. what I want to do is BOLD the row when the word 'Jeff' is found in column B, so in this example A8 to N8 would be BOLD, I need to have the blue and yellow remain. When I copy my conditional format through the sheet, the blue and yellow shade goes away. I'll have over 50 of sheets like this one and 'Jeff' will appear in different rows. I'd rather not use VBA so I was thinking there might be away to do this with conditional formatting...thanks to all you Excel Gurus!!!!
Bookmarks