Conditional formating

[selkov]

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?

 

[Tom Urtis]

VBA cannot detect color changes in a cell from Conditional Formatting. CF does not actually change the color index property, only the appearance of the cell. You need to compose your VBA code to test for the condition itself, not the appearance of the result of the condition. Post back if you get stuck.

 

[mj0lnr]

Selkov,

don't know if this will help you, but this site has a ton of info you might be looking for.
http://www.cpearson.com/excel/CFColors.htm

HTH,
A.