View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default conditional formatting a row

=IF($S3<"cleared",1,0)

"Belinda7237" wrote:

I want an entire row to be struck through if the entry is column s is "cleared"

I am using conditional formatting by highlighting a row and using the
formula featu

=IF($S3,"<cleared",0)

and its not working. Do i have the formula incorrect?