Conditional Formatting
 

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?

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.


Mike SB Wrote:
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?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=389387