apply conditional formatting to negative cell values

D

dona

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

Thanks
 
B

Bob Phillips

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)
 
D

dona

That's great, all sorted now, thank you

Bob Phillips said:
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)
Click to expand...
 
Top