E efish New Member Joined Jan 8, 2004 Messages 35 Jan 13, 2004 #1 I would like to black out or strikethrough lines that produce a #VALUE! result from a spreadsheet that uses a formula to produce a date. I've tried conditional formating but it does not seem to work for the #VALUE! result. Any suggestions?