Is it possibly to create a macro that if column D = VISA and column R is highlighed light red with Dark Red text and Column T is blank it will delete that row? I wasn't sure if that is possible when you use conditional formatting. The Conditional formatting finds duplicate data within a column. TIA!
Conditional Formatting cannot delete cells, rows, or columns. It can only format them.
You clearly use a formula to set the colours using CF. Use the same formulae, in a loop to select and delete the rows.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks