Home > conditional formatting, Forms, vlookup > Timesheets – Conditional Formatting, Vlookup, & Weekday formula

Timesheets – Conditional Formatting, Vlookup, & Weekday formula

MS excel’s conditional formatting feature allows you to highlight data based on certain criteria and especially in MS Excel 2007 there are many options in terms of what you can bring to light and how.
Since time allowed we also gave you a bonus tip on this one – how to write a simple Vlookup formula on a named range so you can being in data from a set list based on other criteria.

This is useful in creating a timesheet as you will see because timesheets are very much dependent on having a date in there, and it is handy to have today’s date light up to bring attention to it. When designing forms it is always good to make it as easy as possible to use. Adding little bells and whistles like this can help your end user. Formatting goes a long way to, but we did not get into this. E-mail us at classes@nerdenterprises.com for a copy of the timesheet we use at Nerd Enterprises, Inc. as well as the sheet created in this video tutorial.

Please enjoy the video tutorial: http://nerdenterprises.acrobat.com/p31944487/


Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: