Quote:
Originally Posted by jeffreybrown
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.