View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bee Bee is offline
external usenet poster
 
Posts: 46
Default Conditional format

Hi, how do I display a cell as follows:

If it's <50, show it as a %
If it's 50 show it as a decimal

It needs formating in the actual cell that the manager would enter a figure
into.

Thanks