asked on
Navigate to a specific colored cell upon opening - Excel
Worksheet where row 1 starting with cell F contains dates at a 45 degree angle. The dates have conditional formatting. Yellow for weekends and Red for today's date. The color is FILL not text color. Also, columns A-E are frozen (locked) in place to scroll horizontally for the dates.
Is it possible that upon opening that today's date (Red fill) is positioned to be the first full date visible? With the 45 degree angle there would be two date cells to the left that are partially in view.
Thanks for any assistance or guidance
Is it possible that upon opening that today's date (Red fill) is positioned to be the first full date visible? With the 45 degree angle there would be two date cells to the left that are partially in view.
Thanks for any assistance or guidance
Microsoft Excel
Last Comment
Martin Liss
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014