• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Excel Conditional formatin

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
Taras
Asked:
Taras
1 Solution
 
Rgonzo1971Commented:
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
 
TarasAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now