View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Belinda7237 Belinda7237 is offline
external usenet poster
 
Posts: 106
Default conditional formatting a row

Its still not working - this is strange as in a previous version of my file I
had it working right. Is there a way to view existing conditional formatting
in a workbook?

"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?