Forum Discussion
Scott Cox
Jul 29, 2017Brass Contributor
Setting Print Areas Not Working in Excel 2016
I'm trying to establish print areas for my Excel sheet. I’ve done this many times before. I'm no expert, but I'm not a newbie either. I can’t get Excel to take what I input. No error messages are generated, but after I exit, Excel will revert to some odd page sequence in the print area field that makes no sense and certainly isn't what I entered. I’ve tried entering the cell range manually and creating using the mouse to create the print area.
What am I missing?
Thanks.
Select the cells with the dates.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'less than or equal to' from the second drop down.
In the box next to it, enter the formula
=EDATE(TODAY(),-54)
If you use comma as decimal separator, change the formula to
=EDATE(TODAY();-54)
In Dutch:
=ZELFDE.DAG(VANDAAG();-54)
Click Format...
Activate the Fill tab.
Select orange.
Click OK, then click OK again.
Repeat these steps, but with the formula
=EDATE(TODAY(),-60)
or if you use comma as decimal separator
=EDATE(TODAY();-60)
and red as fill color.
7 Replies
Sort By
- Logaraj SekarSteel Contributor
- David1015Copper Contributor
Logaraj Sekar Did that didn't help
- Scott CoxBrass ContributorHow do I do that, "clear and set?"
- Logaraj SekarSteel Contributor