View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Select your columns. Choose Format/Conditional Formatting... Assuming a
cell in row 1 is the active cell:

CF1: =$I1="No"
Format1: Patterns/<red

CF1: In article
,
"Mike SB" wrote:

I have a spreadsheet with 9 columns. The last column is a Yes or No value.
I want to conditional format the entire row of all 9 columns to turn red if
the value in the last column is No. Can this be done? If so how?