Hi,
I want a macro that can perform the following task.
Could you please write me the macro?
Task:
For each worksheet in the workbook,
and for each cell in column A,
after I input something in a cell in column a, the row will be filled by red colour.
However, if the things in a cell in column a is deleted, the red colour will be removed from that row.
thanks