Conditional Formatting Formula Works in 2010; Not 2007

[Stang70Fastback]

Hey guys. I've got a simple, and likely stupid question. I've created what amounts to a "vehicle assignment board" in Excel. There are a list of routes that vehicles could be assigned to, and then a block marked "spares" with all the available vehicles listed, one in each cell (just numbers.) When a vehicle is assigned to a route, I need it to be grayed out in the "spares" block.

This all works fine using the following conditional formatting code for each vehicle (3101 being the vehicle in this case) where it simply checks to see if the corresponding number is present in any of the other cells:

=OR(EXACT(3101,$B$30:$B$129))

However, this only seems to work Access 2010. It is meant for use where I work, but those computers run 2007 and for some reason the conditional formatting does not work on those. The cells don't get grayed out. Is there something about that formula that is not compatible with 2007, and if so, is there an alternative code that would do the trick?

Thanks guys!

EDIT: I think I just solved the problem. I used a COUNTIF function instead and just set it equal to anything greater than 0. I guess 2007 just didn't like something about the other function or the way I was using it.

=COUNTIF(B30:B129,3101) > 0

Thanks anyway guys. Sorry for the trouble!

[arlu1201]

Thanks for posting the solution. In future, you can post your solution as post 2. So other users can easily distinguish between the question and the answer.

[:) Sixthsense :)]

Not sure what you are talking about?

this only seems to work Access 2010

In access do you able to refer the range? as =OR(EXACT(3101,$B$30:$B$129))?

or if it is excel do you think this method is right?
=OR(EXACT(3101,$B$30:$B$129))

what is the need of using exact function with Numerics? can you please explain?
3101 is a single criteria then why you are comparing it with range of cells?
The function / method you chosen for your CF which don't have any logic, but you are claiming that the office versions causing trouble, is it so?