Conditional DELETE

  • Thread starter Thread starter RayD
  • Start date Start date
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.
 
RayD,

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

HTH
Anders Silvén
 
Thanks..

RayD,

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

HTH
Anders Silvén
Click to expand...
 
You must log in or register to reply here.

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

More than 3 Conditions 2
Conditional format based off of a logical if statement 3
Copying Conditional format 1
***Conditional Formatting Multiple Cells*** 1
Way to find if conditional formatting triggered? 1
Three condition "if" statements 2
Conditional Formatting 4
how do have 2 conditional formats for one cell 2

Back
Top