Hi, I am trying to make a macro or even an if statement (preferably a macro) which will only grab certain criteria from a cell. Here is my situation:
If cell A1 is yellow, then copy just the yellow format and make cells A2 - A20 yellow as well. The problem I have is the macro i have just copies the cell formats which changes some of the cells from A2 - A20 from a customized number format to a general number format. Is there any way to do this?
Thanks in advance.
If cell A1 is yellow, then copy just the yellow format and make cells A2 - A20 yellow as well. The problem I have is the macro i have just copies the cell formats which changes some of the cells from A2 - A20 from a customized number format to a general number format. Is there any way to do this?
Thanks in advance.