Hi I am new to this forum and I have a question that is probably pretty easy to answer.

I want a cell to turn green if another cell is within a range of another.
A1=30
B2=25-29
C2 will turn green

I am doing conditional formatting. I obviously can make C2 turn green when B2 equal just 25 or another single number but I cannot figure out the range thing.

Any help would be greatly appreciated.

I am working on MAC excel 2004

Thanks