conditional formatting text

[quincy]

i have a drop down menu of teams. there can only be one of two correct choices. I want the cell to change color if if any team other than the two are selected and remain clear if no team is selected.

[thinkspac]

Can you provide your workbook and what values you are looking to highlight, etc?

[quincy]

Segres Family NFL 2012 Picks v1.1.xlsb

using excel 2007

[quincy]

For example, I would like cell D3 to turn red if any team other than DAL or NYG is selected. If possible, have it referenced to cell B3.

[thinkspac]

Hopefully someone else can come along with a better solution, but this is what I can offer for now:

Change all of your variable (drop-down) cells to an "inactive" color such as a light to medium grey.

Add conditional formatting variables for each row based on the two possible (correct) choices and have them revert to "no color".

Sorry I couldn't come up with a "one-click" solution for you.

[quincy]

thanks. i'll give it a try.

[Haseeb Avarakkan]

Select C3:U305, then in conditional format,

=ISERROR(SEARCH(C3,$B3))*SEARCH("@",$B3)

Apply the format

[vlady]

maybe also

=SEARCH($D3,$B3) - only could do that

[quincy]

Select C3:U305, then in conditional format,

=ISERROR(SEARCH(C3,$B3))*SEARCH("@",$B3)

Apply the format

Thank you so much. That is exactly what I was looking for. The only thing now is that only works for that first section. How do I get it to work for the rest of the sheet?

[Haseeb Avarakkan]

Sorry for the delay.

in Conditional Forma 'Applies to' type =$C$3:$U$305

[quincy]

Unfortunately its still not working. Can you take a look at it and see?

[quincy]

Segres_Family_NFL_2012_Picks_v1.1.xlsb

Here is the file Im trying to format.

[Haseeb Avarakkan]

See the attached quincy.

Segres_Family_NFL_2012_Picks.xlsb