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??