Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell border is dotted line | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
blank cell turns to 0 | New Users to Excel | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |