Conditional Formatting Question

...almost certainly but we need to the workbook to be able to understand your layout and comment with some certainty.

What do you mean by highlighting? Do you mean paint the cell a colour? I don't believe conditional formatting can deal with that, you'd need a macro.

If however you were to 'mark' a selection by entering a character in the adjacent column B then conditional formats on the other sheets could work provided the highlighting colour was the same for all cells. If however you paint cells different colours then a macros will be required.

Hi,

Please clarify the multiple columns aspect. Your example only has one column. In addition are you painting cells lots of colours?

Often with these tasks when we learn what the end game is and what's important to the user we can sometimes offer quite different ways of giving the user what's important to them. I'm not saying that may be the case with you but it's worth asking the question.

You have a master list of teams. What determines which teams appear on each sheet. Is there some rule or are they arbitrarily populated. If there's some rule it's worth considering whether you need separate sheets when a single sheet could be generated at run time by the same rule. Just some thoughts...

Forgive me for not being familiar with what I suspect is American football.

So would this work.
Given a list of players in column A, and alongside in column B the position in which they play, column C would be a drop down pick list of Team Names.
You would go down the list of players and pick a Team in column C
Column D could be warning cells which would result in a warning if at any time you exceeded the number of players in a team, or if the number of players for a particular position exceeded a standard pre-defined number.

From the database that would result you could have reports to list an analysis of all the players for a particular team, or a report to list all positions by team, or all players by position..etc.