Excel EXCEL - using a date dependant formula to hide rows


Joined
May 20, 2016
Messages
3
Reaction score
0
Hi,
I use a multi sheet spreadsheet at work to track outstanding tasks.

I would like to write a formula to take today's date and hide the row if it is:
1- less than a week since the last entry
or;
2- hide the row if it from the current month.

I would also like to write a formula that hides the row or column if all cells in use in that row or column have been checked.

Thank you in advance for your assistance.
Ed
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,510
Is it necessary to hide the row? The only way you might be able to do that is with a macro, but I think it would be complicated and messy. A more simple way would be to use conditional formatting - for example you could make the text a light grey (or even white) if the conditions are met. It wouldn't hide the row, but it would mean the other rows stand out by comparison.
 
Joined
May 20, 2016
Messages
3
Reaction score
0
No, the rows or columns need to be hidden, the sheets are used to track outstanding tasks by guys in the field so need to be able to be referenced quickly, and either weekly or monthly the task is due again.
There are up to 200 rows and about 20 or 30 columns on some of the sheets.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top