apply conditional formatting to negative cell values

I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?

Thanks

Just set the condition to less tan and a value of 0 in CF.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dona" <[email protected]> wrote in message
news:[email protected]...
> I am creating a time sheet and want to show negative values in red. Does
> anyone know how to do this?
>
> Thanks

That's great, all sorted now, thank you

"Bob Phillips" wrote:

> Just set the condition to less tan and a value of 0 in CF.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "dona" <[email protected]> wrote in message
> news:[email protected]...
> > I am creating a time sheet and want to show negative values in red. Does
> > anyone know how to do this?
> >
> > Thanks
>
>
>