Conditional Formatting

M

Mike SB

I have a sheet of 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?
 
M

Morrigan

Let's say Column I is last column containing "Yes" or "No"

Select A1:H1 -> Conditional Formatting -> Formula is

=IF($I1="No",1,0)

Set Background colour to red -> OK

Copy A1:H1 -> Paste Special -> Formats


Hope it helps.
 
Top