Microsoft Excel Tutorial for Beginners #8 – Formatting Pt.3

MotionTraining asked:


Learn how to combine conditional formatting with Excel functions.

Related Posts

bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
tabs-top


13 Comments »

  1. maxlarosam Says:

    Your voice is like a massage on my brain, and I am learning so much in such a soothing and gentle way! You really are a master teacher—obvious by the droves of fans you have.

    comment-bottom
  2. statoilx Says:

    Thank you so much!

    comment-bottom
  3. skiesdiver Says:

    thanks very much for the valuable lessons

    comment-bottom
  4. teepants Says:

    very good videos!

    comment-bottom
  5. Tonty53 Says:

    Continua l’apprendimento…
    Ho una certa curiosità per la prossima lezione che spiegherà i diagrammi.

    comment-bottom
  6. kiranreddyk82 Says:

    hellow sir, this is kiran,,,i have learned total excel with this excel tutorials thank you very much. you are really very good teacher…the way you explaining is amazing

    comment-bottom
  7. MotionTraining Says:

    Hi tangy1212. Yes, it can be done. Click the Tools menu and select Options. Click on the Edit tab and make sure the “Extend list formats and formulas” check box has a tick in it. Once this is done then Excel will include conditional formatting from the previous row as you add new rows of data.

    comment-bottom
  8. tangy1212 Says:

    Thanks for the video, very helpful. Just a quick question: I noticed that if you add another row of information, the conditional formatting does not apply to that new row. Is there anyway to automatically conditional format the new row, or do we have to do it manually?

    comment-bottom
  9. MotionTraining Says:

    Hi latinnic22, Thank you for the generous comments! I’m pleased I was able to help you. I do have plans for some PowerPoint tutorials, but can’t say exactly when they’ll be ready – hopefully very soon!

    comment-bottom
  10. latinnic22 Says:

    Thanks a lot MASTER ! You’re just a great teacher. I’ve learnt a lot from your videos and i congratulate you for your good job and the capacity of teaching others. I have a question, do you have videos for power point ?

    Thanks again and KEEP IT UP !

    comment-bottom
  11. MotionTraining Says:

    Hi annaanna1228! Thank you for the comment and I am pleased the tutorials are helping you. I am hoping to put more tutorials up over the coming weeks on Excel and other Microsoft Office programs including PowerPoint, Word and Access. Thanks again for your kind words.

    comment-bottom
  12. annaanna1228 Says:

    Thank you very much. Everyday, I repeat this tutorial. Do you teach other subjects? I would love to learn, you are easy teacher to learn….keep posting more please, and current I am studying #8.

    comment-bottom
  13. annaanna1228 Says:

    Thank you very much. Everyday, I repeat these tutorial. Do you teach other subjects? I would love to learn, you are easy teacher to learn….keep posting more please, current I am studying #8.

    comment-bottom

RSS feed for comments on this post. TrackBack URL

Leave a comment