Format entire row based on cell contents

Select your entire range and invoke the Conditional Formatting feature from the Format menu.

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

=$A1="Yes" where A1 is the top most cell in your select where the word "yes" is to appear. Change as necessary.


Click Format and select your background colour.

Click Ok, click Ok again to finish.

To get the drop down yes/no validation... go to Data|Validation and select List from the Allow menu and in the Source box type: Yes,No

I think I could do it.
First you use conditional formating to color the row, then use validation to make a list of Yes or No to choose.
I also made a sample.

Thanks - Thought it would be much more complicated than that!

How would i then copy this to work on a row by row basis for the entire worksheet?

Also, what do i need to enter if e.g. i wanted it to turn red if someone entered 'Maybe'.

Thanks again,

Tim.

p.s. Thanks for the drop down list info.... so simple, yet i've never used it!

Well if you select the entire range like I said, you shouldn't have to copy the formatting... but if you didn't, then copy the entire row, select where you want to copy the formatting and go to Edit|Paste Special and select Formats....

To copy the Validation, select the cell with the validation and copy it.. go to cell(s) to copy to and then go to Edit|Paste Special and select Validation.

To add another condition, re-invoke the CF dialogue and click Add, repeat the formula except use $A1="Maybe". Click Format and pick Red.

To add "Maybe" to your list, just re-invoke Data Validation and add Maybe to the Yes,No list.