VBAM Games Forums

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.

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.

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

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).