View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Albannach Albannach is offline
external usenet poster
 
Posts: 2
Default 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.