Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~C
 
Posts: n/a
Default If cell is not blank, then line out row

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John Michl
 
Posts: n/a
Default If cell is not blank, then line out row

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell border is dotted line Naz Excel Discussion (Misc queries) 0 October 31st 05 05:17 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
blank cell turns to 0 LMB New Users to Excel 2 April 25th 05 03:57 PM
?? Extra blank lines in 'address' cell after exporting to Excel Hadyn Pkok Excel Discussion (Misc queries) 4 April 15th 05 11:34 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 08:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"