Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Microsoft Excel Tutorial for Beginners #22 - Date & Time Pt.3 - IF & Conditional Format

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
12,864
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jun 15, 2011

Visit MotionTraining at http://www.motiontrainingweb.com
Learn how to combine date calculations with IF functions and Conditional Formatting to make your spreadsheets more user friendly. More tutorials soon.

  • likes, 2 dislikes

Link to this comment:

Share to:
see all

All Comments (6)

Sign In or Sign Up now to post a comment!
  • Do you offer any tutorials on vlookup functions, VBA, c#, and PHP? The job I am trying to get requires knowledge in these areas. You can email me at: mccollumrealty@gmail.com

  • Thank you so much for taking your time to make these tutorials.  I have learned so much, and I really appreciate the time and energy you have put into making them and posting them.

    I am using Excel 2007 and I am having trouble with making more than one conditional format. I can do one just fine, but I have yet to find a place where I can add more with out messing up the current one. Any advice is welcome.

    Thanks again for your hard work!

  • First of all, thank sou very much for these tutorials, they helped me out so much.

    I have a little problem with the formating:

    Somehow the conditional formating doesn't work that way on excel 2007, it always shows me an error message: "in conditional formating, criteria for colored scales etc. relative references can't be used" (roughly translated from German)...so I'm at a loss.

  • Hi

    Firstly I would like to say many thanks for your excellent tutorials they have been extremely informative. I work with spreadsheets that can sometimes contain 30,000 lines and the area I would wish for support with is to change the date format. For myself one of the systems that i use shows the date as for example, 20110101 for Jan 1st 2011, can you show how this can be changed to show Jan 1st 2011 please.........BR Mark

  • Another useful video!

    Thanks so much and looking forward to the next one.

  • Really good thank you, easy enough for me to understand!

    Why don't you offer all your videos on one disk to buy..would be easier for me?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more