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