Can Excel cell formatting be included in an IF statement?

N

neeses

We run a macro that selects duplicates and formats with background with a
color. We need to include that cell formatting in an IF statement. Can it be
done and, if so, what would be the syntax?
 
B

Bob Phillips

No, but you can add conditional formatting to the cell, and test the value
there and set the format accordingly.
 
N

neeses

Bob,

Thanks for the reply. My next question is: Is there some way to delete cells
with the formatted background, either through a macro or some function?
 
B

Bob Phillips

Do you mean CF formats

Sub FCs()
Dim cell As Range
Dim fc As FormatCondition

For Each cell In ActiveSheet.UsedRange
If cell.FormatConditions.Count > 0 Then
For Each fc In cell.FormatConditions
fc.Delete
Next fc
End If
Next cell

End Sub

or ordinary formats

Dim cell As Range

For Each cell In ActiveSheet.UsedRange
cell.ClearFormats
Next cell
 
Top