View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Conditional Formatting Row & Text

One way:

Select your columns (or entire sheet) with a cell in row 1 active (or
else adjust the row number, below). Format/Conditional Formatting...

CF1: Formula is =$L1<"yes"
Format1: <font/<red,bold

In article ,
Clark wrote:

I have a spreasheet with 12 coloums. The last coloum has a value of either
"yes", "no", or null. I need to conditionally format the spreadsheet so if
the value is either "no" or null the entire row is in red with a bold type
face. If the value is "yes" then the row is black and in normal type face
(not bold).

Any suggestions?