Is it possible to apply the combination of two different conditional formatting rules to the same cell in Excel?

Asked by Last Modified  

3 Answers

+2 Basic Excel Advanced Excel

Follow 4
Answer

Please enter your answer

Yes, it is possible to set multiple conditional formats and also to even have them active at the same time. So if one formatting only specifies a text colour and the other only a background, then you can get both effects in a cell. The very tricky thing is that once you set it, you will not be able to...
read more
Yes, it is possible to set multiple conditional formats and also to even have them active at the same time. So if one formatting only specifies a text colour and the other only a background, then you can get both effects in a cell. The very tricky thing is that once you set it, you will not be able to unset formatting, so you need to switch to the " Red Border" that is preset before actually adjusting your pre-determined desired format. For example, there is a table that contains the name (Column A) and subject wise marks (Columns B to G) of students of a class. Say the class has 50 students. Row 1 will heave headers so that data will be populated in Rows 2 to 51. One level of conditional formatting that can be applied to cells B2 to G51 is that if the value of the cell is greater or equal to 35, the cell must turn green. The second level of conditional formatting can be set as if the marks of that subject are more significant than the class average; then the font must turn Bold. Hence, in the first case, a cell is a part of range A2: G51, and in the second case it is a part of column B, C, D, E, F or G. Depending on the value, a cell can become both Green as well as BOLD. There is one more thing. You can select the option of stopping further rules to be applied if the first rule is run TRUE. Hope this helps read less
Comments
Dislike Bookmark

Yes, by creating a new rule we can customize to more than one rule
1 Comments
Dislike Bookmark

Web Expert

Yes using filter query we can do that, or putting up and connection between both the cells
Comments
Dislike Bookmark

View 1 more Answers

Related Questions

Can a person learn advanced level MS Excel through YouTube videos?
You can learn MS Excel on Youtube. Whether you are a complete beginner or advanced user of Excel, there are several video tutorials available at every skill level. They teach you everything by making you...
Ramkumar
0 0
7
Linear Programming in Excel ?? Can someone can solve just 1 question of Linear Programming in Excel ?? I am ready to pay. Thanks
Hi Gary I might be able to help you please share your question with me and hopefully would be able to help you on the same.
Garry
0 0
5
Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything in the range which are in - in a colour and positive in one single colour. How can that happen so can anyone please help me on it?
1. First you have to select the range of cells where you want to apply conditional formatting 2. You have to select conditional formatting from Home tab in Excel window 3. There will be many categories,...
Charan
Which course can be related to MIS executives, Since I have past experience in data base related job I want to try for MIS profile. So kindly suggest me which course suits me for the same profile.
Hi, You can check our course - Analyse and Visualize with Excel. Excel is the most popular tools used by analyst and MIS manager for getting insights from data. Create powerful Dashboards to enable data driven decision making.
Martin
How can I create an organization chart in MS Excel?
Best option would be smart art tools for creating an organisational chart.
Poojashree
0 0
5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Excel Tip: Conditional Formatting To Highlight First Value Among Duplicates.
In Column “C”, I have product list and some of them are duplicates. My requirement is to format with background color of green for 1st found value among the duplicates. To solve this, I used...

Karthik Dale

0 0
0
VBA Function -
Using FORMAT Function in VBA we can modify the format of Numbers, Dates, Times & String. Syntax: FORMAT(expression, format, , ) 1. Formatting "Numbers" using FORMAT function in VBA SUB Format_Numbers() MsgBox...

Naga Satyanarayana Anantapalli

0 0
0
Avoid VLookup function in excel, instead use index and match combination
Avoid VLookup function in excel, instead use index and match combination. Reason: 1) Index and Match combination will be faster than Vlookup function. In order to proof this you can create 1000 rows...

Umasankar Natarajan

0 1
0
MS Excel: Formulas and Functions: Listed by Category
MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....

Siddhartha Mahapatra

0 0
0
Slicer in Excel
Have you every tried Slicer option in Excel? There are lot many features in excel which go unnoticed even if they are visibleAs you know, one of the powerful tool in excel is Pivot table which summarizes...
R

Rakesh R

2 0
1

Recommended Articles

Why Should you Learn Microsoft Office

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

What is Applications Engineering all about?

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Find Microsoft Excel Training classes near you
Microsoft Excel Training classes in Bangalore
Microsoft Excel Training classes in Delhi
Microsoft Excel Training classes in Mumbai
Microsoft Excel Training classes in Hyderabad
Microsoft Excel Training classes in Chennai
Microsoft Excel Training classes in Pune
Microsoft Excel Training classes in Gurgaon
Microsoft Excel Training classes in Kolkata
Microsoft Excel Training classes in Noida
Microsoft Excel Training classes in Ghaziabad

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you