FormatCondition = True?

[macdian]

Hi,

I'm trying to use a macro to delete a cell if it IS conditional formatted.

It seems right now that the colorvalue of the font is NOT stored in Font.ColorIndex, and so my IF statement based on that is not working either.

Here's the statement I am trying to use:

Public Sub DeleteHighlighted()
Set rng = Selection
For Each c In rng
        If c.FomratCondition = True Then
           c.Clear
        Else
        End If
    Next c
End Sub

edit: This is the formula I'm using for the conditional format:

=COUNTIF($V:$V,U1)>0

Help is much appreciated!

 

[Zack Barresse]

Hi,

I'm trying to use a macro to delete a cell if it IS conditional formatted.

It seems right now that the colorvalue of the font is NOT stored in Font.ColorIndex, and so my IF statement based on that is not working either.

Here's the statement I am trying to use:

Public Sub DeleteHighlighted()
Set rng = Selection
For Each c In rng
        If c.FomratCondition = True Then
           c.Clear
        Else
        End If
    Next c
End Sub

edit: This is the formula I'm using for the conditional format:

=COUNTIF($V:$V,U1)>0

Help is much appreciated!

would something like this work for you?

Sub del_cond_form()
ActiveCell.SpecialCells(xlCellTypeAllFormatConditions).Select
Selection.FormatConditions.Delete
End Sub

 

[Tom Urtis]

Conditional formatting does not change the actual format properties of a cell; it just looks like it does. Try clearing the cells based on the condition of V:V and U (whatever it is you are COUNTIF'ing). Also, there's no need for an Else clause in your If block because the condition is either met or it isn't, which means if it isn't the loop will move on to the next cell anyway.

 

[macdian]

Thank you firefytr! It's perfect!

 

[Zack Barresse]

just beware that it will delete all conditional formats!

 

[macdian]

Actually, I thought it worked, but it just removes the formatting. Unfortunately, I need to clear any cell that IS formatted, or satisfies the above formula...I guess.

Macdian

 

[Zack Barresse]

so you want to clear the conditional formatting and the contents?

or just the contents?

 

[macdian]

But...thanks very much for the effor Zack. This message board is truly full of wonderful people such as yourself.

Macdian

 

[macdian]

What I want to do is if a Cell's conditional formatting is Active (ie, the cell is BOLD and RED...as I've made in my formatting)...I want to delete the contents....but not any cells other than those that satisfy the conditional format.

 

[Tom Urtis]

The approach I posted does what you say you want...evaluate the cell based on the condition and clear it if it meets the condition.