if calculations

[TeddyBearDJ]

I am trying to figure out a way to make a cell change colors if a certain
condition is met. For example, if cell f4 is 192.27 or above, then the cell
font should change to RED to show it is over the number it should be. If
not, then it can stay whatever color it is.
Can anyone figure out how to make this calculation??

Hi

You need to use Format/Condional Formating.
Select the cell and go to this option. From the dialog box set Cell Value Is
along with >=192.27.
Then select a format and you're done!

Andy.

"TeddyBearDJ" <TeddyBearDJ@discussions.microsoft.com> wrote in message
news:7E76D7EC-3E55-48B5-B773-923594BCD567@microsoft.com...
>I am trying to figure out a way to make a cell change colors if a certain
> condition is met. For example, if cell f4 is 192.27 or above, then the
> cell
> font should change to RED to show it is over the number it should be. If
> not, then it can stay whatever color it is.
> Can anyone figure out how to make this calculation??

[Biff]

Hi!

Try this:

Select cell F4
Goto Format>Conditional Formatting
Select Formula Is
In the little box on the right enter this formula:

=F4>=192.27

Click the Format button
Select the desired style(s)
OK out

Biff

"TeddyBearDJ" <TeddyBearDJ@discussions.microsoft.com> wrote in message
news:7E76D7EC-3E55-48B5-B773-923594BCD567@microsoft.com...
>I am trying to figure out a way to make a cell change colors if a certain
> condition is met. For example, if cell f4 is 192.27 or above, then the
> cell
> font should change to RED to show it is over the number it should be. If
> not, then it can stay whatever color it is.
> Can anyone figure out how to make this calculation??