Solved

Excel Conditional formatin

Posted on 2013-11-18
2
103 Views
Last Modified: 2013-11-27
I do not have a lot experience with excel conditional formatting.
I need help with this situation.
I have e.g.  Workbook  named “ Test”  with a spreadsheet “Test_A”.
  in Test_A spreadsheet I have column A populated with  data in it and column B populated with alphabet data.
I need to put condition to color column A cell in yellow when value of column B is “X” in the same row.
How to this in side the same spreadsheet (Test_A) and how to do this if it column “B” is in another spreadsheet Test_B.

Any Idea?
0
Comment
Question by:Taras
2 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

Use this type of Formula in the conditinal formatting

in the same sheet

=$B2="X"

if condition in another sheet

=Sheet2!$B2="X"

see example

Regards
CF.xlsx
0
 

Author Closing Comment

by:Taras
Comment Utility
Thanks.
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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

744 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

21 Experts available now in Live!

Get 1:1 Help Now