# Excel Macro

Closed
shaleem100 Posts 1 Registration date Wednesday April 23, 2014 Status Member Last seen April 23, 2014 - Apr 23, 2014 at 11:11 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 15, 2014 at 11:05 AM
Hello All,
I am trying to create a macro with formula. I need help in there. I have to get a formula for a column for more than one sheet. The formula will be the same but the range that the formula will be used are different. So for example - the formula will be applied on sheet 1 from AN5 to AN50. For sheet two, the same formula will be applied from AN5 to AN70.
Any help in this will be appreciated.
The formula that I am trying to use is =ROUNDUP(IF(AP7=0,0,((AP7)/1.7)+IF(AS7>=18,1,0))+BC7,0)+BA7

Thank you
Shahid
Related:

## 2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 28, 2014 at 11:53 AM
Hi Shaleem,

Sorry to inform you that it is not possible to create a macro with a formula.

Besides that it is unclear to me why you want to use a macro.

Best regards,
Trowa
Hello

Then what option do I have with that
I also need another help if on excel sheet I need to highlight certain columns and the criteria is that there is a special wording in Column X, all those rows that have that special word have to be highlighted in a color anything else needs to be remain as is. IS there a easy way to do this
Let me know
I am also available on my cell
[number removed - Privacy]

Thanks
Shahid
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 15, 2014 at 11:05 AM
Hi Shahid,

You say you want to apply a formula to a range. Then enter the formula in the first cell of that range and drag it down to apply it to the rest of the range.

For your second question I would use Conditional format. Where you would use a formula like: =A1="Special word".

Let us know if further assistance is needed.

Best regards,
Trowa