Solved

# Excel Conditional formatin

Posted on 2013-11-18
125 Views
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
Question by:Taras

LVL 49

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 39658500
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

ID: 39681885
Thanks.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.