Cell formatting based on another cell criteria

[kjacobpetersen]

I have a spreadsheet of products (both current and obsolete). I have a column with the product number, one with the description, and one for whether or not it is current. The cell that tells whether or not the product is current has "yes" or "no" typed in. How can I format my first column to change the fill color to red if the current cell has no typed into it. Thanks.

 

[SteveO59L]

Use Format, Conditional Formatting, with the "Formula Is" option.

i.e

to format A1, use

Formula Is =C1="No"