If cell is not blank, then line out row

C

~C

I have a spreadsheet. When I enter in a date in the "Date Reply Sent"
column, the issue is now closed. I would like that row to line out. Is
there a way to say the following:

If cells in column B are not blank (contain a date), then line out that
entire row

Thanks,

~C
 
J

John Michl

Use conditional formatting where the formula is something like
=NOT(ISBLANK(B1). The resulting formula could be strikethrough however
this only puts a line through characters, not spaces in cells. To
"line out" the entire row, you might us conditional formatting as above
but shade the cells.

Don't forget you can also use Data > Filter > AutoFilter to hide all
rows that are complete.

- John
www.JohnMichl.com
 
Top