Excel Question

Off-Topic Discussion
Post Reply
User avatar
Tyrel Lohr
Vice Admiral
Vice Admiral
Posts: 1466
Joined: Thu Oct 04, 2007 3:48 am
Location: Lusk, WY
Contact:

Excel Question

Post by Tyrel Lohr »

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. :wink:
[i]"Touch not the pylons, for they are the messengers!"[/i]
nimrodd
Commander
Commander
Posts: 135
Joined: Sat Oct 06, 2007 1:59 am
Location: DFW, TX

Re: Excel Question

Post by nimrodd »

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.
Jimmy Simpson
nimrodd
Commander
Commander
Posts: 135
Joined: Sat Oct 06, 2007 1:59 am
Location: DFW, TX

Re: Excel Question

Post by nimrodd »

It should actually be:
=COUNTIF(F2:F100,C2)>=1
Jimmy Simpson
User avatar
Tyrel Lohr
Vice Admiral
Vice Admiral
Posts: 1466
Joined: Thu Oct 04, 2007 3:48 am
Location: Lusk, WY
Contact:

Re: Excel Question

Post by Tyrel Lohr »

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]"Touch not the pylons, for they are the messengers!"[/i]
Post Reply