Conditional format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try a custom format of

[<.5]0%;General

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top