I have a spreadsheet that incorporates conditional formating in colum a.
I.E. if conditons are true the cell color will be yellow.
I would like to write a VBA script to look for a specific color cell, copy & paste the entire row to another spreadsheet & then delete the original row.
I think I can do most of it, but I am stumped on the initial criteria to recognize the colored of the cell?
any ideas?
I.E. if conditons are true the cell color will be yellow.
I would like to write a VBA script to look for a specific color cell, copy & paste the entire row to another spreadsheet & then delete the original row.
I think I can do most of it, but I am stumped on the initial criteria to recognize the colored of the cell?
any ideas?