Conditionally formatting numeric data and text differently

A

Albannach

I am trying to do conditional formatting on cells in Excel 2007 such that if
they contain numeric data, they will be formatted in one font, style, and
size, and if they contain text (e.g. "Out of range"), another combination.
The nearest I can find is to format specific text, but even when I enter the
possible text entries, the system will allow me to change only style,
underline, color, and strikethrough, but not font or size. And even then, I
can see no way to format numeric data and text differently, or to do so
without specifying the text itself.
 
D

Dave

Hi,
Use this formula in the conditional formatting:
=ISTEXT(A1)
Change the A1 to your ref and set format you want for text.
As far as I know, conditional formatting cannot change font size.
Regards - Dave.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditionally formatting text and numbers differently 1
conditionally formatting 3
Comparison of columns using Conditional Formatting 3
Conditional formatting in Excel 2007 - font choice grayed out 0
find and replace numeric strings in larger text strings 8
Using Logical OR on text in Conditional Formatting 4
Excel Conditional Formatting 1
conditional formatting with numbers and text 1

Top