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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 15, 2014 at 11:05 AM
Related:
- Excel Macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
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
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
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
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
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
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
