Excel help needed!

[YALE]

Can anyone make me an Excel, "If/Then" formula for a column, or just the cell in that row, that makes it so it automatically highlights the entire row with either green if yes is entered, or red if no is entered? I'll paypal you $20 if it works.

Caveat: If someone at work beats DFWmustangs to the punch, this offer will be null and void.

[YALE]

Got it. Thanks for nothing, the 4 people that read this thread before this post.

[ceyko]

Hell, post up that formula if ya don't mind.

[YALE]

Hell, post up that formula if ya don't mind.

I figured out how to get away without using it, but I'm pretty sure you can build something in the Conditional Formatting tab. If I can get it figured out, for sure I'll post it. Then you can all send me a nickle when you use it.

[8mpg]

when you have excel questions...hit up momostallion

[Skidmark]

Like you mentioned, you can use Conditional Formatting.

Highlight the row you want, click on Conditional Formatting drop down, then new rule.

-Format only cells that contain
-Then you can change it to Cell Value equal to No
-What I did next was click on Format and change the fill to red
-Click OK

Then you want to create a new rule for changing Yes to green.

[Mr_Fiux]

momostallion = Master and Ruler of all Excel kingdoms.