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

apply conditional formatting to negative cell values
 

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" wrote in message
...
I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?

Thanks

apply conditional formatting to negative cell values
 

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" wrote in message
...
I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?

Thanks