Excel and conditional Formatting

[shaunholtz]

Hey all - I'dd appreciate any assistance on this, i'm a little stuck.
Pretty good knowledge of excel, but I can't figure this one out.

Here the background. I have a lineup form for a soccer team. I have
all the rostered players listed at the bottom. As I enter the exact
name of the player in a specific postion, I want the name at the
bottom to format differently. I would like to strikethough.. the
formatting part is easy.. it's the conditional formula, i'm having
problems with....

If you need more info let me know.. Thanks!

Shaun

 

[Bob Phillips]

Use a formula of

=OFFSET(this_cell,1,0)=""

 

[shaunholtz]

Use a formula of

=OFFSET(this_cell,1,0)=""

--
__________________________________
HTH

Bob









- Show quoted text -

This didn't seem to do anything.. I applied the formula as a
conditional format to the cell that already contained the text and
changed "this_cell" to the correct cell identifier(I40)

 

[dranon]

Hey all - I'dd appreciate any assistance on this, i'm a little stuck.
Pretty good knowledge of excel, but I can't figure this one out.

Here the background. I have a lineup form for a soccer team. I have
all the rostered players listed at the bottom. As I enter the exact
name of the player in a specific postion, I want the name at the
bottom to format differently. I would like to strikethough.. the
formatting part is easy.. it's the conditional formula, i'm having
problems with....

If you need more info let me know.. Thanks!

Lots of ways to do this. Almost all rely on your positions being
defined as a range. The conditional formatting would check the range
for the existence of the name in the range. If it finds it, it
changes the formatting.

So, assume your positions are defined in A6:A15 and you are entering
the names of the players in B6:B15.

Let's assume a player entered in your player roster is at cell D50.

In the conditional formatting for D50 put:

=ISNUMBER(MATCH(D50,$B$6:$B$15,FALSE))

 

[shaunholtz]

Lots of ways to do this.  Almost all rely on your positions being
defined as a range.  The conditional formatting would check the range
for the existence of the name in the range.  If it finds it, it
changes the formatting.

So, assume your positions are defined in A6:A15 and you are entering
the names of the players in B6:B15.

Let's assume a player entered in your player roster is at cell D50.

In the conditional formatting for D50 put:

=ISNUMBER(MATCH(D50,$B$6:$B$15,FALSE))

That works like a champ! Sorry I didn't get to try it sooner.

Thank you so much for your help, I will apply it to my actual lineup
sheet.

 

[dranon]

That works like a champ! Sorry I didn't get to try it sooner.

Not a bother. Thanks for reporting back.

Thank you so much for your help, I will apply it to my actual lineup
sheet.