Conditional DELETE

R

RayD

Hello everyone,

Before I get into the meat and potatoes of this macro, column "H"
will have a red (5) background put there by conditional formatting.

So really not sure if this approach will work, but here goes.

Check range Sheet1 (H5:H1968) for cell background = Red (5)
if TRUE do nothing.

If cell background = White (46) (or default I think), then DELETE
each cell contents in Sheet1 column (I5:I1968) that condition applies
too. -Thanks

Any help would be appreciated.
 
A

Anders S

RayD,

AFAIK the color applied by Conditional Formatting can not be read programmatically. Use the CF condition instead.

HTH
Anders Silvén
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting disappears when cell contents deleted 2
Conditional format based off of a logical if statement 3
Conditional Formatting with VBA 4
How can I convert conditional formatting into explicit formatting? 0
Conditional Formatting in Excel 2003 2
Copying Conditional format 1
delete duplicates 0
Way to find if conditional formatting triggered? 1

Top