Conditional Formatting in Excel

[Guest_imported]

I want to check that a column contains only formula or blanks, ie. no text or manually typed numbers. Is it possible to achieve this with VB, with offending cells having text or background colour changed?

 

[ilses]

Hi Geoff,

Seed code to help you get started:

Dim cell As Range

For Each cell In Application.Selection
If Not cell.HasFormula Then
If Not IsEmpty(cell.Value) Then
cell.Interior.ColorIndex = 3
End If
End If

Next cell

Good luck.


IS

 

[Guest_imported]

Perfect, Thanks!