Conditional Formating

[Dale McCulloch]

In column B I have a list of mostly names. A few cells contain numbers or are blank. I have to use conditional formating to highlight the cells that do not contain text.


Thanks

 

[VoG]

Try

=NOT(ISTEXT(B1))

 

[T. Valko]

In column B I have a list of mostly names. A few cells contain numbers or are blank. I have to use conditional formating to highlight the cells that do not contain text.


Thanks

Use the "formula option" and use a formula like this:

=ISNONTEXT(B1)

 

[Dale McCulloch]

worked perfectly, Thanks

 

[T. Valko]

worked perfectly, Thanks

You're welcome. Thanks for the feedback!