I will bold it manually.

Even though done manually, there must be some thought process behind why the cell is bolded.

Maybe the cell is less than or greater than a number...
Maybe the cell contains a certain word...

If you can bold by some type of search/pattern, then you can easily use that criteria in your if statement and further use conditional formatting to bold the cell.

Other than that, if there is no rhyme or reason when the cell is bolded, you will need to use VBA as Pecoflyer has pointed out.

Maybe it will help if I advise what its for. It is a football pool sheet with 120+ people picking different teams to win. For example one may pick Carolina (A6) and another Atlanta (B6). So on my master sheet I want to be able to put a W for the team that one and then use formula to see if the W is bold on each one of the other sheet that contains the picks, so that they get the points in C6. ( I will use this for each game.

That is always a good idea, as I'm not fully convinced you need VBA, plus, it's hard to create VBA when you don't know the real design of the sheet.

How about you put together a small representative sample of what you have and what you desire! Attach here.

Here is a copy of my first sheet. Players submit picks to me and I enter them into spreadsheet. This sheet is master sheet. So I make all final changes here. So for example Jacksonville won this morning. So I would like to put a w in it and it will fill across the spreadsheets. All of the ones that are bold in the next 120 sheets are the only ones that matter and will receive points.. Hope that helps.

Attached Files

SAMPLE NFL.xlsx (14.8 KB, 11 views)