Excel Question

Do you have something to say that doesn't have anywhere else to go? Post it on the Off-Topic forum.
User avatar
Tyrel Lohr
Vice Admiral
Vice Admiral
Posts: 1416
Joined: Thu Oct 04, 2007 3:48 am
Location: Lusk, WY
Contact:

Excel Question

Postby Tyrel Lohr » Sat Jul 04, 2015 5:40 am

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:
"Touch not the pylons, for they are the messengers!"

nimrodd
Commander
Commander
Posts: 134
Joined: Sat Oct 06, 2007 1:59 am
Location: DFW, TX

Re: Excel Question

Postby nimrodd » Sat Jul 04, 2015 9:41 pm

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: 134
Joined: Sat Oct 06, 2007 1:59 am
Location: DFW, TX

Re: Excel Question

Postby nimrodd » Sat Jul 04, 2015 9:42 pm

It should actually be:
=COUNTIF(F2:F100,C2)>=1
Jimmy Simpson

User avatar
Tyrel Lohr
Vice Admiral
Vice Admiral
Posts: 1416
Joined: Thu Oct 04, 2007 3:48 am
Location: Lusk, WY
Contact:

Re: Excel Question

Postby Tyrel Lohr » Sat Jul 04, 2015 11:29 pm

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).
"Touch not the pylons, for they are the messengers!"


Return to “Off-Topic”

Who is online

Users browsing this forum: No registered users and 2 guests