Excel and conditional Formatting

  • Thread starter Thread starter shaunholtz
  • Start date Start date
S

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
 
Use a formula of

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

--
__________________________________
HTH

Bob









- Show quoted text -
Click to expand...

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)
 
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!
Click to expand...

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))
 
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))
Click to expand...

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.
 
Back
Top