Hey, quick question

Hey guys, I am at work, I have a quick question for yall.

How do I paste this =IF(V4="SMS",(AJ4*AA294),"") while only incrementing the V4 by 1 and AJ4 by 1, so the next cell would be ...

=IF(V5="SMS",(AJ5*AA294),"") , I keep trying to copy and paste, and excel automatically increases the AA294 =( .. thanks for the help in advance.


Oh also, one more question, if have one column which i put in just Y or N , is there a way if that field has Y in it, it would automatically highlight the row from a certain cell to another cell in that row?