Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting numeric data and text differently
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally formatting numeric data and text differently
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. "Albannach" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally formatting text and numbers differently | Excel Discussion (Misc queries) | |||
Conditional Formatting - Code to colour 3+ text values differently | Excel Discussion (Misc queries) | |||
Numeric date to text..formatting question | Excel Discussion (Misc queries) | |||
converting text to numeric data | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) |