Use The Format Painter


  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

Use The Format Painter

This video tutorial shows how to use the formatting painter in Excel.
  • Total Hits: 17067

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating


  • Total Votes: 144 votes

  • Category: MS Excel/General Formatting

  • Submitted on: 2008-04-27 00:59:21

  • Submitted By: Devesh Khanna

  • Set as Favorite


* Highlight the data cells you wish to consider..
* In the main tool bar go to Edit > Go To..
* Press the "Special" Button .
* In the Go To Special Dialog box" select "Conditional formats".
* Select "Same" then press the "OK" button.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 38.19%  55
 Two starsTwo star  Vote LeftVote MiddleVote Right 10.42%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.81%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 11.11%  16
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 28.47%  41

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.