12/14/15

How to Use Conditional Formatting Based on Another Cell?


In this tutorial we are learn about how to conditional formatting based on another cell? In this tutorial we will learn how to create different formatting rules, how to edit and copy our formatting rules in ms excel, and also how to do conditional formatting based on another cell. It is a really powerful feature when it comes to applying different formats to data that meets certain condition. It can help you highlight the most important information in your spreadsheets and identify variances of cells' values with a quick glance.
How to create conditional formatting rules?
1.      First select the range of cell which we want to create conditional formatting.
2.      Then we go to conditional formatting command and press the option we will see the drop
         down list.
3.       And select the Highlight cell rules, and select Greater than option.


















4. when we select the Greater Than option we see a Greater than option as given in below image.












In this image we see, First when we want to format cell greater than 1000,so we will enter the value of 1000. He highlights the number which is greater than 1000. Same process do in all option.

Preset conditional formatting
Microsoft excel has several presets we can use to quickly apply conditional formatting to your cells. They are grouped into three categories:

1.      Data Bars
2.      Color Scales
3.      Icon set

Data Bars:- First we discuss about Data bars, Data bars are horizontal bars added to each cell, much like a bar graph.



Note:-  Its not work when we select the alphabetical cell. Its work when we select Numerical cell.

Color Scales:- Now we discuss about Color Scales, Color scales change the color of each cell based on its value. Each color scale uses a two- or three-color gradient. For example, in the  -Yellow-Red- Green  color scale, the highest values are yellow, the average values are red and the lowest values are green.




Icon set:-  Now we discuss about Icon Sets, Icon sets the change the color of each based
on its value. Each directional sign shows icons in data cells by applying desired Condition.

For Example, Red sign is low number yellow sign shows medium number and green sign shows highest number.

In above image shows that Red color show Lowest Number, yellow color shows Medium Number and Green color shows Highest Number.We also choose shapes, indicators and Ratings to show the Numbers.

For More icon set ruler, we will go to conditional formatting select Icon sets and go to more rules and press it. Now we see New formatting Rule box as image given as below.




















In this image we will go to Select a Rule Type and select Format all cells based on their values the go to Edit the Rule Description and We set format all cells based on their Values as we want.
If you have found any mistake or have any doubt related to above how to conditional formatting based on another cell? tutorial then comment below. If you like the tutorial the follow on twitter and also like us on facebook.

25 comments:

  1. HOW TO MAKE A SALARY SHEET IN EXCEL

    ReplyDelete
  2. click the link below as you given
    https://www.youtube.com/watch?v=DGD0UMe2A4k

    ReplyDelete
  3. hey mahesh please help me in pivot table and various tyoes of table format

    ReplyDelete
  4. hey mahesh please help me in pivot table and various tyoes of table format

    ReplyDelete
  5. formaat as style in ms excel is so simple

    ReplyDelete

  6. I need to apply the format to the whole sheet of March and not just column A of march. Also, is there a way to search the whole sheet of "roster" and not just "D:D"? Would indirect("Roster"&"!A:F") work?

    ReplyDelete
  7. The peron names and roles are contained in a single cell: is this correct? If so, is it possible to seperate them into two columns?

    ReplyDelete
  8. The Post seems to be good i really gather lot of information from the post thanks for sharing this awesome post.
    http://www.staffcontrol.com/

    ReplyDelete
  9. I saw two other comparable posts although yours was the most beneficial so a lot try here

    ReplyDelete
  10. Even when using the data templates, it is not guaranteed that different vendors of TEDS-compliant systems will interpret what data goes into the electronic templates in the same way. yük hücresi

    ReplyDelete
  11. These days, clients may acquire a broken phone to any of the wireless repair places.Handy reparatur

    ReplyDelete
  12. I was in a café a week ago, and a cell phone began to ring. Out of nowhere like coordinated robots everybody's hands went for their tote, pocket or belt and quickly raised their cell phone to answer the call. mobile tracker app

    ReplyDelete
  13. You can find the information you need in a safe and clandestine manner. A tracker is the perfect solution for employers, law enforcement, parents and even a suspicious lover. telefon takip programı

    ReplyDelete
  14. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. parental control app

    ReplyDelete
  15. In this tutorial we will learn how to create different formatting rules and becomes the mathematician. commercial Garage Door Opener installation systems that keep your office doors Spring and maintain Door security perfect all year long.

    ReplyDelete
  16. Write more, that's all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what you're talking about, why throw away your intelligence on just posting videos to your blog when you could be giving us something enlightening too read?
    고스톱

    ReplyDelete
  17. Аs tҺe аdmin of this site іs աorking, no uncertainty very shօrtly іt will be well-known, due to its feature contents.
    스포츠토토

    ReplyDelete
  18. You present a very well-written article and with some awesome information which is very helpful, like me as reader. Thanks for sharing it and also please visit our great site below.
    한국야동

    ReplyDelete
  19. GREAT JOB! This blog presents a very valuable information. Keep up the good work! Visit our website too. Thanks!
    토토사이트

    ReplyDelete

  20. Interestingly you write, I will address you'll find exciting and interesting things on similar topics. 사설경마


    ReplyDelete
  21. I like your post. It is good to see you verbalize from the heart and clarity on this important subject can be easily observed... dark0de market link

    ReplyDelete
  22. I’ve been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the web will be a lot more useful than ever before. dark0de market url

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Mad About Computer. Powered by Blogger.