The following lines were added (+) and removed (-):
=== Conditional Formatting: Color Entire Row Based of Value of Text Cell ==User asks, "''One of the columns I have consists of either "Yes" or "No" text field. I want to have the color of an entire row dependent on the value of a single text field in that row, for the entire excel spreadsheet. Furthermore, this is text data as opposed to numeric field data. So, what I am looking for is to influence the row's color based on the data in one column.''"Answer: Select all the columns of rows to be involved. On the toolbar menu goto "Format" then "Conditional Formatting..."; Change condition 1 "Cell Value Is" to "Formula Is"; If the column you want to base your conditional on is column B then use the formula, =$B2="No" And set condition as desired.