Cloror in a formula - with certain criteria
 

Is there a way to make a color change if the result of the formula is above
or below a certain number OR result?

Cloror in a formula - with certain criteria
 

Conditional formatting
--
David Biddulph

"Farmer Ted" wrote in message
...
Is there a way to make a color change if the result of the formula is
above
or below a certain number OR result?

Cloror in a formula - with certain criteria
 

hi
yes. use conditional formating.
on the menu bar....
formatconditional formatting
condition1-if cell value is..less than..your number
pick your color
contition2-if cell value is..greater than..your number
pick your other color.
you might want to consider greater that or equal to.
less than or equal to..
regards
FSt1
"Farmer Ted" wrote:

Is there a way to make a color change if the result of the formula is above
or below a certain number OR result?

Cloror in a formula - with certain criteria
 

Thanks. . .I knew it was a simple answer. . .I thought it would be better to
ask the question than spend hours tooling around myself. Thanks alot

"FSt1" wrote:

hi
yes. use conditional formating.
on the menu bar....
formatconditional formatting
condition1-if cell value is..less than..your number
pick your color
contition2-if cell value is..greater than..your number
pick your other color.
you might want to consider greater that or equal to.
less than or equal to..
regards
FSt1
"Farmer Ted" wrote:

Is there a way to make a color change if the result of the formula is above
or below a certain number OR result?

Cloror in a formula - with certain criteria
 

you are welcome.
regards
FSt1

"Farmer Ted" wrote:

Thanks. . .I knew it was a simple answer. . .I thought it would be better to
ask the question than spend hours tooling around myself. Thanks alot

"FSt1" wrote:

hi
yes. use conditional formating.
on the menu bar....
formatconditional formatting
condition1-if cell value is..less than..your number
pick your color
contition2-if cell value is..greater than..your number
pick your other color.
you might want to consider greater that or equal to.
less than or equal to..
regards
FSt1
"Farmer Ted" wrote:

Is there a way to make a color change if the result of the formula is above
or below a certain number OR result?