Those Pesky New Digits of the New Year

Posted by TetonTrekker on January 6, 2018 in Excel, Tips for the common user | ∞

Now that it is a new year, sometimes we forget to date things with the correct year. Use conditional formatting to alert yourself of a wrong year entered in excel.

Tags: conditional formatting, custom error checking, data entry, MS Excel, year end

Julie Wilson
PO Box 9397
Jackson, Wy 83002
Contact Form
- Please Note:
- ⚠ I change mean comments to happy ones.
- TOS & Privacy Policy
- As an Amazon Associate I earn from qualifying purchases.
File DLs

Dream House Excel Data 269
Pauline’s Letters
Follow
RSS - Posts
Subscribe

Enter your email address to receive notifications of new posts by email.

Join 189 other subscribers

Email Address
Artwork Credit
Photos for Sale
- Sunflowers
- Fall Pumpkins
- Farmers Market Root Vegetables
- Greenriver Lake
- Farmers Market Sunflower
Recent Posts
- Self Employed
- #045 Trigger Warning
- Music: Good for the Soul
- #036 Ringie-Dingies: Erupting Telemarketer
- #101 Cat Herding
- Ringy-Dingys
- #019 The Quest for the Holy Grail of Staplers
My Projects
- TetonTrekker Web Designs
- inScoreOrder Music Library
My Gravitar

Teton Trekker

Mom, wife, Pampered Chef Independent Consultant, computer geek, web designer, musician, ski bum, photographer, bicyclist, camper, glamper, fishing woman, treasure hunter, bookkeeper, office wizard, trekking through life in Jackson Hole.

Personal Links
- TetonTrekker.com
- inScoreOrder.com
- Julie: Girl Friday
- Azusa Alumni
Verified Services
View Full Profile →
Follow Me
- deviantart
- facebook
- twitter
- pinterest
- linkedin
My Tweets
Community
Tags

#fakecalls 1099 algebra blog blogger blogging compatible files computer problems conditional formatting Construction Billing convert file copy machine coworkers custom error checking Data data entry detective work email employees fake news graphic Julie's Dream House logo Math Movie Moment MS Excel MS Word order of operation PEMDAS photos privacy resize security Social Media Sorting Sorting text with numbers taxes telemarketers The Ugly translate file truth UGH waiting your turn xerox machine year end
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Julie: Girl Friday

Those Pesky New Digits of the New Year

Share this:

Like this:

Pauline’s Letters

Subscribe

Artwork Credit

Photos for Sale

Recent Posts

My Projects

My Gravitar

Teton Trekker

Personal Links

Verified Services

Follow Me

Community

Tags