Solved

Excel Conditional formatin

Posted on 2013-11-18
2
136 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 50

Accepted Solution

by:
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

by:Taras
ID: 39681885
Thanks.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 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