VBA for Conditional Format

[pahickham]

Hello,

I need help acquiring a VBA that can make a list of all the red cells that I've conditionally formatted with a range. The cells I've conditionally formatted can turn red, green, or yellow. When one of the cells turns red (meaning it's out of a given range) I would like for it to be copied onto another list either at the bottom of the excel spreadsheet or on a new one, whichever I can get help with. An example of one of the ranges would be

Red:
=IF(AND(OR($B$4<0.001,$B$4>0.004),$B$4>0,$B$4<=18),TRUE,IF(AND(OR($B$4<0.003,$B$4>0.008),$B$3>18),TRUE))

Green:
=IF(AND(AND($B$4>0.001,$B$4<0.004),$B$3>0,$B$3<=18),TRUE,IF(AND(AND($B$4>0.003,$B$4<0.008),$B$3>18),TRUE))

Yellow:
=IF(AND(OR($B$4=0.001,$B$4=0.004),$B$3>0,$B$3<=18),TRUE,IF(AND(OR($B$4=0.003,$B$4=0.008),$B$3>18),TRUE))

I've attached a reference spreadsheet. Any help would be appreciated.

[ptmuldoon]

I'm really not sure what your asking. Are analyzing multiple cells to test if they are within your number from? Should we be checking all of Row 4? Or just cell B4 when it changes color? Are you trying to do this for mulitple worksheets or other?

And if it turns red, what do you want copied below? Can you provide a before and after example?

[xladept]

See if this is near to what you wanted:

Please Login or Register  to view this content.

[pahickham]

Sorry I wasn't very clear the first time, but basically what I want is a VBA that can gather all the cells that turn red from the conditional formatting after the information is manually inputted. I would like for it to be able to copy the title of the cell, which should be in column A, into a designated area below the spreadsheet or if possible onto another spreadsheet. Here's a before and after example.

[xladept]

Then maybe:

Please Login or Register  to view this content.

[pahickham]

Thanks for the help but this doesn't seem to be working for me.

[ptmuldoon]

Thanks for the help but this doesn't seem to be working for me.

What was wrong with it? I ran the code by xladept on your before sheet, and it gave the results shown in your after file. Is there something else it needs to do?