Data Validation highlites?

[nowwecanmakewar]

I have a coulple Data Validators (list) set up for a couple of columns. Lets say the list is Yes and No. I wanted to know if its possible that when one of my columns validator is set to no if it could highlite the columns coresponding row. Does that make since?

To re word this Each of my rows are a user account, each column is details about that users such as username, address, active ect. If active is set to no I would like it to highlite that entire row with a certain color. (user). Thanks.

[NBVC]

Select all rows that you want to set format to.

Go to Format|Conditional formatting

Select Formula Is from 1st drop down and enter formula:

=And($B$1="No",$C2="No")

where B1 contains your data validation list and C2 is the first column/row in the selected rows that can contain "No". Adjust as necessary. Don't change the $ signs though. These "freeze" certain rows and columns.

Click Format and choose colour from the Pattern tab and click Ok.

Click Ok to finish.

[VBA Noob]

Try conditional formatting

http://www.contextures.com/xlCondFormat01.html

Select all cells then say your col with Col D enter this formula

=$D1="no"

VBA Noob

[nowwecanmakewar]

Where is this format button, I cant find it anywhere on 2007 edition. This is why I keep asking questions because the tutorials say go to FORMAT>CONDITIONAL but doesnt say where I can find it

[VBA Noob]

Does this link help

http://office.microsoft.com/en-us/ex...655491033.aspx

VBA Noob

[NBVC]

See here:

http://office.microsoft.com/en-us/ex...189951033.aspx

[nowwecanmakewar]

PERFECT VIDEO thank both of you guys so much!!