thanks, in my previous version that was working the formula i used was:

=$S3="cleared"

I must have wrote over it in my new version, now that i have reentered it
works. Thanks for all your help and patience!

"Joel" wrote:

You can see the conditional formating by clicking on the cell and then Go to
menu Format - Conditional Format the same way you entered the Conditional
formating.

"Belinda7237" wrote:

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?