RE: Conditional Formatting

Giganews Newsgroups
Subject: RE: Conditional Formatting
Posted by:  Elkar
Date: Tue, 16 May 2006

Try this:


Where "formula" is your original formula.


"Emily" wrote:

> Hi. I am trying to create a conditional formula so that if I have 0, it
> returns 0, if I have a number greater than or equal to 30 to show 30, and
> anything in between 0 and 30 it shows said number. How do I do this? Thanks.



In response to

Conditional Formatting posted by Emily on Tue, 16 May 2006