I need help figuring out how to search a cell on more then one condition. For example my formula right now is =IF(B7="w",C7, "0"). However I only want it to = c7 if b7 is also bold. I am willing to use something other then bold if needed just not sure what. T



Thanks in advance.

How did B7 get bolded?

I will bold it manually.

This cannot be achieved by a formula. VBA is needed. Is that OK?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

That would be fine if it works. I haven't used VBA

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, 9 views)

So you are going to control the "w" from the master sheet?

It seems to me, the bold is going thru more trouble than neccesary. On the master sheet, enter the winner in column D and the points values in column C. All the individual sheets are set up the same way with the exception of the forumla in column C. If they select the correct winner from the data validation in column D and is matched with column D on the master sheet then they get the points and if not, zero

Attached Files

SAMPLE NFL.xlsx (14.5 KB, 9 views)

I am not sure that will help me unless I am not understanding it correctly.
The picks are all submitted to me in multiple different formats. So it is me entering in the data on each sheet, unless it is submitted in excel.
In your example what formula would I use to compare their pick to winning team? I am looking for something that will auto fill all sheets once master sheet is filled out.

On each individual players worksheet, beginning in C7 you'll see =IF(D7='Week 4'!D7,'Week 4'!C7,0).

Now on the Week 4 worksheet you pick the winner in D7 with the points in C7.

If it's you entering all the data, then I'm guessing the bold is applied by you?

If you group all the worksheets you can apply all these changes at once.