Conditional Formatting - excel 2010

Seamus2626
Seamus2626 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013

Commented:
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
Top Expert 2014
Commented:
use this URL for conditional forwarding.
http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

also attached your sheet with conditional forwarding.
formula.xls
Most Valuable Expert 2013

Commented:
See example of sheet with formatting applied

regards, barry
cf-barry.xlsx

Author

Commented:
Sorry it took so long!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial