Page 1 of 1

Excel Question

Posted: Sat Jul 04, 2015 5:40 am
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:

Re: Excel Question

Posted: Sat Jul 04, 2015 9:41 pm
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.

Re: Excel Question

Posted: Sat Jul 04, 2015 9:42 pm
by nimrodd
It should actually be:
=COUNTIF(F2:F100,C2)>=1

Re: Excel Question

Posted: Sat Jul 04, 2015 11:29 pm
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).