Solved

Conditional Formatting - excel 2010

Posted on 2014-03-05
4
343 Views
Last Modified: 2014-07-07
Hi,

I have attached a ss, in the tab Test, there is a pivot table.

I want conditional formatting such that if the category = A, then the customer is marked as red

Can someone apply and explain how?

Many thanks
MI-.xlsx
0
Comment
Question by:Seamus2626
  • 2
4 Comments
 
LVL 50

Expert Comment

by:barry houdini
ID: 39907551
Hello Seamus,

You can follow these steps:

Select the range C12:C58

Conditional Formatting > New Rule > Use a formula to determine which cells to format

Type this formula in the box

=$D12="A"

Click "format" button and apply red fill or font as required > OK > OK

all done!

regards, barry
0
 
LVL 13

Accepted Solution

by:
Santosh Gupta earned 500 total points
ID: 39907558
use this URL for conditional forwarding.
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

also attached your sheet with conditional forwarding.
formula.xls
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 39907570
See example of sheet with formatting applied

regards, barry
cf-barry.xlsx
0
 

Author Closing Comment

by:Seamus2626
ID: 40179909
Sorry it took so long!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now