IfBold/IsBold ???

gazza52 · Nov 24, 2003

I have what I thought would be a simple task however, as I cannot find any info on it, I may be wrong.

The scanario is a large list of competitors playing a knockout competition (Golf). I only want to write their names once so I thought I could list each match (2 players) and as a player wins his match I would change his name to bold (ie CTL + B). This would then automatically carry over to the next match.

With the above in mind, below is an example of a match where Players 1 and 3 would be "bold" in column A. C3 and C4 would have the formula to select the players who name is in bold:

(A1) Player 1
(A2) Player 2
>>>>>>>>>> (C3) Player 1
>>>>>>>>>> (C4) Player 3
(A5) Player 3
(A6) Player 4

I Have been trying various formulas using IfBold and IsBold and have tried some of the UDF's from the forum but I am at the headbanging stage. Any assistance would be appreciated. I am not very experienced with Visual Basic if the help goes in that direction.

onlyadrafter · Nov 24, 2003

Hello,

Could you not use CONDITIONAL FORMATTING where in cell A1 you have the CONDITION as

Formula is =B3=CELL("contents",A1)

A2 CONDITION as

Formula is = B3=CELL("contents",A2)

A5 CONDITION is

Formula is = B5=CELL("contents",A4)

and A6 CONDITION is

Formula is = B3=CELL("contents",A5)

You can then use the format painter for other cells.

gazza52 · Nov 26, 2003

Thanks for your input Onlyadrafter however, I do not think I explained my problem very well. So I have included a quick and dirty abbreviation table of what I want below.

Book2.xls

A

B

C

D

E

F

G

H

I

J

K

1

Player1

2

Player2

3

Player1

4

Player4

5

Player3

6

Player4

7

Player4

8

Player6

9

Player5

10

Player6

11

Player6

12

Player7

13

Player7

14

Player8

15

16

17

Example1-AfterinitialDrawbeforeanygamesplayed.

Example2-After2matches.ThewinnersofeachmatcharemadeboldbyCtlB.

Sheet1

The table would be much larger than above and the idea is to only input the names once in column A, which I do via a macro. I now want a formula which will automatically update the following games in Column C and E (as per exampe two) when I convert one of the names from each match in column A to Bold (via Ctl B).

I hope the table looks better when I post than the preview I am looking at. I have been trying to master Colo's HTML Maker.

Thanks for any help in advance.

fairwinds · Nov 26, 2003

Hi,
One way could be to put an x next to the winner, conditionally format the player next to the x to bold and then bring him on with a vlookup.

Book1

A

B

C

D

E

F

G

H

2

Player1

3

x

Player2

4

Player2

5

x

Player3

6

x

Player3

7

Player4

8

x

Player3

9

Player5

10

x

Player5

11

Player6

12

x

Player5

13

Player7

14

x

Player7

15

Player8

Sheet4

gazza52 · Nov 27, 2003

Thanks Fairwinds,
It worked perfectly. The beauty of this forum is that you get different perspectives on the problem at hand. I was stuck on the "IsBold" and "IfBold" aspect and couldn't see the ripples for the waves.

Happy sailing.

Richie(UK) · Nov 27, 2003

Hi,

As regards the original query, using the following UDF (which is, I assume, similar to what you were using):

Code:

Function IsBold(rng As Range)
    Application.Volatile
    IsBold = rng.Font.Bold
End Function

I got the following results (you will need to press F9 to force a recalculate after adding Bold to a particular cell):

Book1

A

B

C

D

E

F

1

2

Player1

3

Player2

4

Player2

5

Player3

6

Player3

7

Player4

8

Player2

9

Player5

10

Player5

11

Player6

12

Player5

13

Player7

14

Player7

15

Player8

16

Sheet1

HTH

IfBold/IsBold ???

gazza52

New Member

onlyadrafter

Well-known Member

gazza52

New Member

fairwinds

MrExcel MVP

gazza52

New Member

Richie(UK)

MrExcel MVP

Similar threads

Share this page

IfBold/IsBold ???

gazza52

New Member

onlyadrafter

Well-known Member

gazza52

New Member

fairwinds

MrExcel MVP

gazza52

New Member

Richie(UK)

MrExcel MVP

Similar threads

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock