Hi,
I would like to create a macro with conditional formating (3 rules). I have recorded a macro but when I have to set the conditional format, I have to select a field or cell.
However, the field I will have to run the macro on will change from one Excel file to another one.
Is it possible not to select any speficic area for the macro and just select the area just before running this macro (by highlighting the field)?
I really do not think that it is complicated but I do not know how to do it.
I hope this makes sense.
Please help me.
Thanks a lot.
Aurelie
I would like to create a macro with conditional formating (3 rules). I have recorded a macro but when I have to set the conditional format, I have to select a field or cell.
However, the field I will have to run the macro on will change from one Excel file to another one.
Is it possible not to select any speficic area for the macro and just select the area just before running this macro (by highlighting the field)?
I really do not think that it is complicated but I do not know how to do it.
I hope this makes sense.
Please help me.
Thanks a lot.
Aurelie
