How do you create a conditional formatting for a cell to test the cell's value against the contents of another column to look for any matches (just looking for a TRUE / FALSE result). I need to know for a project I'm working on.
Excel Question
-
Tyrel Lohr
- Vice Admiral
- Posts: 1466
- Joined: Thu Oct 04, 2007 3:48 am
- Location: Lusk, WY
- Contact:
Excel Question
A question for those that are better at Excel than I am:
How do you create a conditional formatting for a cell to test the cell's value against the contents of another column to look for any matches (just looking for a TRUE / FALSE result). I need to know for a project I'm working on.
How do you create a conditional formatting for a cell to test the cell's value against the contents of another column to look for any matches (just looking for a TRUE / FALSE result). I need to know for a project I'm working on.
[i]"Touch not the pylons, for they are the messengers!"[/i]
Re: Excel Question
Go into Conditional Formatting and choose "Use a formula to determine which cells to format".
In the formula enter the following "=COUNTIF(F2:F100,C2)>1", where C2 is the cell you are testing and F2:F100 is the column you are testing against.
In the formula enter the following "=COUNTIF(F2:F100,C2)>1", where C2 is the cell you are testing and F2:F100 is the column you are testing against.
Jimmy Simpson
-
Tyrel Lohr
- Vice Admiral
- Posts: 1466
- Joined: Thu Oct 04, 2007 3:48 am
- Location: Lusk, WY
- Contact:
Re: Excel Question
Thanks, Jimmy! I thought it should be something like that, but my brain had reached burnout 
I'll go in there and test that. If it works, it will save me quite a bit of time getting this star system information cross referenced (and make it easier to do future map expansions if need be).
I'll go in there and test that. If it works, it will save me quite a bit of time getting this star system information cross referenced (and make it easier to do future map expansions if need be).
[i]"Touch not the pylons, for they are the messengers!"[/i]