Archive

Posts Tagged ‘date formulas’

Timesheets – Conditional Formatting, Vlookup, & Weekday formula

August 26, 2009 Leave a comment

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